"readtable" reads in the wrong data from an Excel spreadsheet.
Show older comments
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"?
Accepted Answer
MathWorks Support Team
on 21 Jul 2020
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.
More Answers (0)
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
on 21 Jul 2020
on 8 Dec 2020
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
