Import Explorer for tables

versión 4.3 (160 KB) por Jan Studnicka
GUI for readtable and datastore. Select / sort table variables and their data types. Read from multiple tabular text or Excel files at once.

356 descargas

Actualizada 21 Jul 2021

Ver licencia

Nota del editor: This file was selected as MATLAB Central Pick of the Week

Read data from one or multiple files (.xls, .xlsx, .csv, .txt) or spreadsheet lists containing tables with the same format and variable names. Interactively select and sort variables and their respective data types to import before reading data into the workspace.
  • select and sort variables
  • de/select multiple variables at once with mouse, Ctrl, Shift and using context menu in the Selected Variables Column
  • choose data types of the selected variables
  • confirm selections and preview
  • read data from selected variables into the table array
Export "import options" to reuse with a new data of the same format when you read data from one file only. Variable with "Import options" can be used as a second argument when calling the function readtable - this syntax is described in the documentation:
When reading from multiple tabular text files (.csv, .txt), you can use the same conversion specifiers that the textscan function accepts for the formatSpec argument:
Import options are automatically detected from your data. However, you can customize some of these options before reading the data into the workspace. For example, you can change "DataRange", "Sheet", "ImportErrorRule" and "MissingRule" if you read data from a single Excel file.

Citar como

Jan Studnicka (2022). Import Explorer for tables (https://www.mathworks.com/matlabcentral/fileexchange/92468-import-explorer-for-tables), MATLAB Central File Exchange. Recuperado .

Compatibilidad con la versión de MATLAB
Se creó con R2021a
Compatible con cualquier versión
Compatibilidad con las plataformas
Windows macOS Linux

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!