Help: xlsread with dynamic range of rows?
1 次查看(过去 30 天)
显示 更早的评论
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
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/145624/image.png)
0 个评论
回答(1 个)
Guillaume
2014-10-7
Simply do not specify a range when you call xlsread:
[num, text, raw] = xlsread('c:\text.xlsx', 1);
0 个评论
另请参阅
类别
在 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!