why reading .xls file using xlsread returns empty variables?

Hello

I have some data in a .xls file. the file content is four colunms. the first row is a header then all others are numbers.

I tried to simply use

[ndata, text, alldata] = xlsread(filename)

but it does not return anything

ndata =

     []

text =

  0×0 empty cell array

alldata =

  1×1 cell array

    {[NaN]}

How can I solve this problem?

Thanks!

[KSSV]

Try readtable.

[Nora Khaled]

same problem

0×0 empty table

[Mathieu NOE]

can you share your excel file ?

[Nora Khaled]

Thank you!

your comment made me realize the problem.

The problem is the data is not in the first sheet of the .xls file.

Answer 1

[Nora Khaled]

The problem is the data is not in the first sheet of the .xls file.

I needed to sort the xls sheets before using

[ndata, text, alldata] = xlsread(filename)

[Mathieu NOE]

you can specify the sheet you want to read

read the help

% Read from a named worksheet:

B = xlsread('myExample.xls', 'MySheet')

[Peter Perkins]

Also, KSSV's recommendation to use readtable instead of xlsread is still worth heeding.

[Mathieu NOE]

yes sure

it's because I'm older and I'm always using "old" functions , but I'm improving lately on new stuff