Read NaN data from excel file

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?

Answer 1

[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.

[Anna Stasinopoulou]

Thank you very much

[Sulaymon Eshkabilov]

Most welcome!

Answer 2

[SALAH ALRABEEI]

click on import and choose the xls file