MATLAB Answers

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

55 views (last 30 days)
JFz
JFz on 12 Jul 2018
Answered: JFz on 12 Jul 2018
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 Comments

Walter Roberson
Walter Roberson on 12 Jul 2018
What is the name of the sheet in this case?
What does xlsinfo report as the available sheet names?
Meg Glade
Meg Glade on 12 Jul 2018
Do you mind sharing the exact call you are making to readtable (with filename and sheetname filled in)?

Sign in to comment.

Accepted Answer

JFz
JFz on 12 Jul 2018
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 Comments

Sign in to comment.

More Answers (0)

Tags

Products


Release

R2018a

Translated by