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

1 次查看（过去 30 天）
POKA
POKA 2017-8-1
评论： Matthew Eicholtz 2017-8-1
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.

请先登录，再回答此问题。

采纳的回答

Matthew Eicholtz
Matthew Eicholtz 2017-8-1
Does this work?
A = xlsread('test.xlsx','sheet1','A:A');
M = xlsread('test.xlsx','sheet1','M:M');
plot(A,M);
  3 个评论
显示 1更早的评论
POKA
POKA 2017-8-1
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
Matthew Eicholtz 2017-8-1
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);

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by