how to read in unequal columns from an excel sheet

6 次查看（过去 30 天）

Robert Jones 2023-9-11

评论： Dyuman Joshi 2023-9-11

Hello

I have an excel sheet with four column that are unequal in size

How would I read them into 4 matlab arrays?

Thank you

Robert Jones 2023-9-11

also I chose 4 as an example. in realiy they might be in the hundrets

Dyuman Joshi 2023-9-11

"in realiy they might be in the hundrets"

Noted.

And what do you want to do with the different arrays? Do you want to perform some kind of operation/data manipulation on the them? or something else?

Walter Roberson 2023-9-11

readtable() to read all entries together. Then take one variable at a time and trim off trailing empty entries.

Or possibly multiple readtable() or readmatrix() calls with 'Range' parameter indicating which column to read.

Walter Roberson 2023-9-11

Note that multiple calls will be slower.

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

R2022a

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

Translated by