Limit of TEXTSCAN for reading the number of rows of an excel sheet in MATLAB?
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (1)
Walter Roberson
le 30 Juil 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 commentaires
Voir également
Catégories
En savoir plus sur Text Files dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!