MATLAB: Error using xlsread. Worksheet not found

error using xlsreadMATLAB

Warning: Could not start Excel server for import, 'basic' mode will be used. Refer to HELP XLSREAD for more information. 
> In xlsread (line 195)
  In realdata (line 59) 
Error using xlsread (line 257)
Worksheet 'Sheet2' not found.
Error in realdata (line 59)
On_Fl_stg1 = xlsread ('write.xlsx','Sheet2','A2:A4027');

Can someone please help me with this. I am using MATLAB 2019a, and it is unable to read my excel data from 'Sheet2' (the name of worksheet).

However, when I change the name in excel and accordingly in MATLAB code, it works for the 1st time but then again gives the same error on multiple runs.

Best Answer

Warning: Could not start Excel server for import, 'basic' mode will be used. Refer to HELP XLSREAD for more information.

xlsread can only read .xlsx files on MS Windows systems that have Excel installed. On MS Windows systems that do not have Excel installed, and on Mac and Linux systems, xlsread() can only read .csv files.

It is recommended that you use readtable() [R2013b or newer] or readmatrix() [if you have R2019b or newer]

Related Solutions

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;

MATLAB: Problem with xlsread.

That particular .xls file is not readable with xlsread() for OS-X, at least not on my R2014a release (and probably not in versions up to R2015b either as that code did not change.)

The file is a binary .xls file; only text .xls and .csv and .xlsx files can be read in Basic Mode in MATLAB on OS-X or Linux or on MS Windows systems that do not have Excel installed.

You would need to arrange to have the file saved in a different format to read it in MATLAB on OS-X.

Best Answer

Related Solutions

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

MATLAB: Problem with xlsread.

Related Question