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

2 次查看（过去 30 天）
Brad Lindqvist
Brad Lindqvist 2024-9-25
回答： Cris LaPierre 2024-9-25
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?

请先登录，再回答此问题。

回答（1 个）

Cris LaPierre
Cris LaPierre 2024-9-25
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:

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by