Read NaN data from excel file

23 次查看（过去 30 天）
Anna Stasinopoulou
评论： 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?

请先登录，再回答此问题。

采纳的回答

Sulaymon Eshkabilov
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.

更多回答（1 个）

SALAH ALRABEEI
SALAH ALRABEEI 2021-6-5
click on import and choose the xls file

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by