How to select particular column in xlsx file using xlsread function of MATLAB ?

Hi Everybody,

Quite frequent I am to this site nowadays.

I have one xlsx file.I have near about 20-30 columns of mix data type. I want to plot few numerical columns which are spread in between of these columns. I have been using xlsread function like below

 data=xlsread('test.xlsx','sheet1','A1:M70023').

But among these columns I want to plot only A clm vs M clm.How to declare this instead of using long range.

Thanks.

Answer 1

[Matthew Eicholtz]

Does this work?

A = xlsread('test.xlsx','sheet1','A:A');
M = xlsread('test.xlsx','sheet1','M:M');

plot(A,M);

[POKA]

Super!!!.Thankyou so much Matthew Eicholtz.

[POKA]

   Just One more doubt , suppose I have one or two text in my  
numerical  data column which are nothing but bad data. How can I 
plot those column. I mean how to skip those text and plot with rest of the data.

[Matthew Eicholtz]

I'm guessing the samples containing text show up as NaN when you use xlsread? If so, after running the code shown in my answer, you can use:

mask = isnan(A)|isnan(M);
A(mask) = [];
M(mask) = [];

plot(A,M);