"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"?

Answer 1

[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.