why reading .xls file using xlsread returns empty variables?

5 次查看（过去 30 天）

Nora Khaled 2020-11-20

评论： Mathieu NOE 2020-11-20

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!

Mathieu NOE 2020-11-20

can you share your excel file ?

Nora Khaled 2020-11-20

Thank you!

your comment made me realize the problem.

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

Nora Khaled 2020-11-20

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)

Peter Perkins 2020-11-20

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

Mathieu NOE 2020-11-20

yes sure

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

MATLAB Data Import and Analysis Data Import and Export Standard File Formats Spreadsheets

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

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

Translated by