readtable error "Sheet name does not exist or is not supported"

41 次查看（过去 30 天）
JFz
JFz 2018-7-12
评论： honggildong 2021-6-30
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
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
Meg Glade 2018-7-12
Do you mind sharing the exact call you are making to readtable (with filename and sheetname filled in)?

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

JFz
JFz 2018-7-12
Thanks for the help. I just fixed it! Some the date format in the sheet is not readable in Matlab. I changed the Date format in the Excel file and now it is working.

更多回答（0 个）

类别

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

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by