MATLAB: “readtable” reads in the wrong data from an Excel spreadsheet.

excelMATLABreadtable

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

Best Answer

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.

Related Solutions

MATLAB: Reading excel sheetname n extracting data from that using matlab

Using xlsread

num = xlsread(filename,sheet) %Sheet can be a number or an existing sheet name

You can use also xlsfinfo to obtain the sheet names

[status,sheets] = xlsfinfo(filename)

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

You can rename an Excel sheet using the "Name" property of a sheet object. For example the following renames the first sheet of an Excel file:

filename = 'C:\SomeExcelFile.xls';
% Open Excel Automation server
Excel = actxserver('Excel.Application');
% Make Excel visible
Excel.Visible=1;
% Open Excel file
Workbook = Excel.Workbooks.Open(filename);
% Get the list of sheets in the workbook
Sheets = Excel.ActiveWorkbook.Sheets;
% Rename the first sheet
Sheets.Item(1).Name = 'This is sheet 1';

The following code then saves the Workbook, quits Excel and removes the COM server:

% Save the file
Workbook.Save();
% Quit Excel, remove the COM server and delete the related objects
Excel.Quit();
Excel.delete();
clear Excel;
clear Workbook;
clear Sheets;

Best Answer

Related Solutions

MATLAB: Reading excel sheetname n extracting data from that using matlab

MATLAB: How to rename a sheet in Excel using the COM interface in MATLAB

Related Question