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

42 views (last 30 days)
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.

Accepted Answer

Matthew Eicholtz
Matthew Eicholtz on 1 Aug 2017
Does this work?
A = xlsread('test.xlsx','sheet1','A:A');
M = xlsread('test.xlsx','sheet1','M:M');
plot(A,M);
  3 Comments
Matthew Eicholtz
Matthew Eicholtz on 1 Aug 2017
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);

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!

Translated by