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

Help: xlsread with dynamic range of rows?

1 次查看（过去 30 天）
Khanh
Khanh 2014-10-7
回答： Guillaume 2014-10-7
Hi all,
How can I read an excel with unlimited dynamic range of rows? Just stop at the row which has NaN values. I attached my code to make easier for you to understand my problem. It doesn't work, just decribe my question.
n=1000; (maximum number of rows_how could I set it unlimited?)
for i=1:n
range=sprintf('A%d',i);
[num,text,raw]=xlsread('c:\text.xlsx',1,range);
if raw(i,1)==[NaN]
break (break the for-loop)
end
end
result=i-1; (number of rows which doesn't inclued NaN value)
For example: with the following picture, the script will stop at the 22nd row and the result variable will be 21

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

回答（1 个）

Guillaume
Guillaume 2014-10-7
Simply do not specify a range when you call xlsread:
[num, text, raw] = xlsread('c:\text.xlsx', 1);

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by