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

2 views (last 30 days)
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?

Answers (1)

Walter Roberson
Walter Roberson on 30 Jul 2015
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.
  3 Comments
yashvin
yashvin on 30 Jul 2015
It contains a string separated by a comma. At many sections, i am having similarly
'BATON ROUGE METRO, RYAN FLD

Sign in to comment.

Community Treasure Hunt

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

Start Hunting!