"readtable" reads in the wrong data from an Excel spreadsheet.

5 次查看（过去 30 天）
MathWorks Support Team
回答： MathWorks Support Team 2020-12-8
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
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 个）

类别

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

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by