Is it possible to read xls files in matlab where different data types is in the same row?

Hello,

I am currently working on a project where I need to analyze vast amounts of data collected from a measuring machine. The data is collected in a CSV file where each row represents different data points (length, xyz coordinates, etc.); unfortunately, when the data is exported from the measuring machine, multiple tables are created and placed below each other (see attached picture), where it's not possible to alter where each table is placed and unfeasible to manually move each table for every file. I was therefore wondering if theres any way to deal with this issue and read the data points until an empty row is encountered without the use of any loops or if conditions?

Answer 1

[Cris LaPierre]

To address the question asked in the title, yes. Use readtable.

To answer the question asked in your post, it depends what you want the final output to be. If you want to read each table separately, then I don't know of an automated way to do that. If you want to read the entire sheet, skipping empty rows (essentially merage all the tables into a single table), then look into these options for readtable:

• MissingRule
• ImportErrorRule
• EmptyLineRule