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!
4 个评论
KSSV
2020-11-20
Try readtable.
Nora Khaled
2020-11-20
Mathieu NOE
2020-11-20
can you share your excel file ?
Nora Khaled
2020-11-20
采纳的回答
Nora Khaled
2020-11-20
3 个评论
Mathieu NOE
2020-11-20
you can specify the sheet you want to read
read the help
% Read from a named worksheet:
B = xlsread('myExample.xls', 'MySheet')
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
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
