xlsread is not reading the complete excel table when used in 2009b
1 次查看(过去 30 天)
显示 更早的评论
Hello,
Im tried using the readtable in 2009b but it is not compatible. So, used xlsread as below
data = xlsread('TestList.xlsx','C4:AR22');
but it is only reading the last row.
can someome please provide suggestions
thank you
0 个评论
采纳的回答
Cris LaPierre
2023-6-30
The syntax you are using only returns numeric data. My first guess, then, is that your spreadsheet only contains numeric data in the last row.
You can test this by calling xlsread with three outputs:
Inspect the raw variable and see if it has the data you are expecting.
If not, please attach your spreadsheet to your post using the paperclip icon.
0 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!