MATLAB: Undefined function or variable ‘xlsread’.

undefined function or variable 'xlsread'.

I am using MATLAB 9.0.0.341360 (R2016a) with an academic license. Excel is MS Office plus 2016.

I've updated the toolbox chache, didn't help.

>> which -all xlsread
C:\Program Files\MATLAB\R2016a\toolbox\matlab\iofun\xlsread.m

Best Answer

Could you check with plain

which xlsread

? which -all can show items which MATLAB does not consider to be in your MATLAB path directly callable by you.

If it does not show up, then you might need to

resetdefaultpath

Related Solutions

MATLAB: How to save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)

You can save a file in a format compatible with older versions of Microsoft Excel by using the SAVEAS method of Workbooks and specifying an input argument as in the example below:

file = 'C:\myfilename.xls';
xlswrite(file, rand(5)); 
myApp = actxserver('Excel.Application');
myApp.visible = 1;
workbook = myApp.Workbooks.Open(file);
workbook.SaveAs('C:\myfilename2.xls',43);
%Saves the file in a format compatible with MS Excel 95 and 97
myApp.Quit;

MATLAB: Xlsread

You could use xlsfinfo() to get the sheet names and then you'll get the last sheet name.

[A, DESCR, FORMAT] = XLSFINFO('FILENAME')

Normally, 'DESCR' will return all the sheet names in a cell array.

Best Answer

Related Solutions

MATLAB: How to save a workbook compatible with older version of Microsoft Excel using ACTXSERVER in MATLAB 7.4 (R2007a)

MATLAB: Xlsread

Related Question