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

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?

Answer 1

[Walter Roberson]

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.

[yashvin]

Yes you are aboslutely right! OMG!! So how can i read the excel file? It contains floating points and strings!

ff2=['%s','%s','%f','%*s','%f','%f','%f'];

The exact headers is like this!

[Walter Roberson]

The line that is causing the problem, what does it look like?

[yashvin]

It contains a string separated by a comma. At many sections, i am having similarly

'BATON ROUGE METRO, RYAN FLD