how to read in unequal columns from an excel sheet

4 次查看(过去 30 天)
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
  4 个评论
Robert Jones
Robert Jones 2023-9-11
also I chose 4 as an example. in realiy they might be in the hundrets
Dyuman Joshi
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?

请先登录,再进行评论。

回答(1 个)

Walter Roberson
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.

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by