readtable error "Sheet name does not exist or is not supported"
61 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
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 Commenti
Walter Roberson
il 12 Lug 2018
What is the name of the sheet in this case?
What does xlsinfo report as the available sheet names?
Meg Glade
il 12 Lug 2018
Do you mind sharing the exact call you are making to readtable (with filename and sheetname filled in)?
Risposta accettata
JFz
il 12 Lug 2018
1 Commento
honggildong
il 30 Giu 2021
I have the exact same issue. Could you maybe explain your solution further?
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Database Toolbox in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!