Limit of TEXTSCAN for reading the number of rows of an excel sheet in MATLAB?

1 次查看（过去 30 天）

yashvin 2015-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231707-limit-of-textscan-for-reading-the-number-of-rows-of-an-excel-sheet-in-matlab

评论： yashvin 2015-7-30

Hello, My code is

f2 = fopen('Airport Data.csv');
ff2=['%s','%*s','%*f','%*s','%*f','%f','%f'];
D1 = textscan(f2,ff2,'Delimiter',',','HeaderLines',1);
Airport_data=D1{1}

My Airport Data.csv contains about 20000 rows. MATLAB can only read up to 4835 rows. Any help of reading until the end of the file?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

Walter Roberson 2015-7-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231707-limit-of-textscan-for-reading-the-number-of-rows-of-an-excel-sheet-in-matlab#answer_187665

That code is not for reading an Excel sheet, it is for reading a text file with a comma delimiter.

textscan stops reading when the form stops matching. I suspect that you will find that the last entry of what was read will not have a valid value in D{2}(end) or D{3}(end)

Go into an editor or something similar and look at lines 4835 and 3486 and I think you will find that one of the two is not the format you expect.