"readtable" reads in the wrong data from an Excel spreadsheet.
显示 更早的评论
When I read data from an XLSX file into MATLAB using "readtable", the wrong data is read in. I have checked the path to the file that I am reading, and it is correct, but the wrong data in still being read in.
However, if I save the XLSX as a CSV and use "readtable", the correct data is read in to MATLAB.
How do I get MATLAB to read in the proper data when I use "readtable"?
采纳的回答
MathWorks Support Team
2020-7-21
This may be the result of a hidden sheet in the spreadsheet.
When you call "readtable", you can specify the sheet that you would like to read from as follows:
readtable(filename,'Sheet',sheetname)
This will ensure that you read in the correct sheet to prevent you from reading in the hidden sheet.
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
产品
2020-7-21
2020-12-8
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
