清空筛选条件
清空筛选条件

XLSREAD: make rows and columns flexible/dynamic?

1 次查看（过去 30 天）
Stefan
Stefan 2015-2-12
编辑： dpb 2015-2-12
Hi, I would like to read several excel files, but their format differs. Each should start at the same cell (d5) and read until NaN fields (in rows and columns). My code so far is:
n=100;
for i=1:n;
range=sprintf('A%d',i);
USE=xlsread('X:\xx.xlsx','aa');
if USE(i,1)==[NaN];
break;
end;
end;
result=i-1;
How can I add a flexible column and how can I make it to start reading at the 5th row/4th column of the file instead of the first? Thank you!
  1 个评论
dpb
dpb 2015-2-12
编辑：dpb 2015-2-12
Probably simpler is to just read the full file and then select the data subset(s) desired (or, conversely set the unwanted region(s) to []).
Using xlsread in a loop this way will be quite slow, btw.

请先登录，再进行评论。

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

回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by