why reading .xls file using xlsread returns empty variables?

6 次查看(过去 30 天)
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!
  4 个评论
Nora Khaled
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
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)
  3 个评论
Peter Perkins
Peter Perkins 2020-11-20
Also, KSSV's recommendation to use readtable instead of xlsread is still worth heeding.
Mathieu NOE
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

请先登录,再进行评论。

更多回答(0 个)

Community Treasure Hunt

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

Start Hunting!

Translated by