how to read in unequal columns from an excel sheet

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

[Dyuman Joshi]

Any particular reason why you want to store them in 4 different arrays?

[Robert Jones]

yes, these are measured data sets [x1 y1] and [x2 y2] from different sources with different sampling rates

[Robert Jones]

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

[Dyuman Joshi]

"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?

Answer 1

[Walter Roberson]

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]

Note that multiple calls will be slower.