readtable error "Sheet name does not exist or is not supported"
显示 更早的评论
Hi,
I use readtable all the time but never had this error until today: "Sheet name does not exist or is not supported, To check if the sheet is supported, specify the sheet by its worksheet index." Here is the way I am using it:
a = readtable(filename, 'sheet', sheetname);
If I just do a = readtable(filename), there is no error and the output a is a table with the first sheet. If I use an index, it works as well:
a = readtable(filename, 'sheet', 1);
But I need to use sheetname in this case.
What is wrong here?
Thanks for any help!
2 个评论
Walter Roberson
2018-7-12
What is the name of the sheet in this case?
What does xlsinfo report as the available sheet names?
Meg Glade
2018-7-12
Do you mind sharing the exact call you are making to readtable (with filename and sheetname filled in)?
采纳的回答
JFz
2018-7-12
0 个投票
1 个评论
honggildong
2021-6-30
I have the exact same issue. Could you maybe explain your solution further?
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
