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

64 次查看(过去 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 CenterFile Exchange 中查找有关 Database Toolbox 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by