Read NaN data from excel file
41 ビュー (過去 30 日間)
古いコメントを表示
Anna Stasinopoulou
2021 年 6 月 5 日
コメント済み: Sulaymon Eshkabilov
2021 年 6 月 9 日
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 件のコメント
採用された回答
Sulaymon Eshkabilov
2021 年 6 月 5 日
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 件のコメント
その他の回答 (1 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!