Read NaN data from excel file
26 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Anna Stasinopoulou
il 5 Giu 2021
Commentato: Sulaymon Eshkabilov
il 9 Giu 2021
Hello, I want to read an excel file with 2 columns and many rows and I need to read all the data, from row 1 to the last one. The problem is that the first rows are empty excel cells and when using xlsread, matlab ignores them and starts reading from the first not NaN data. Is there anything I can do to fix that?
0 Commenti
Risposta accettata
Sulaymon Eshkabilov
il 5 Giu 2021
If you are using xlsread(), then specify the cell range, e,g: DATA = xlsread('MY_data.xlsx', 'Sheet1', 'A1:D123');
Then you can convert all emppty cells into nan's by using logical indexing using missing data.
2 Commenti
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!