MATLAB: How to get MATLAB xlsread to read, in OS X El Capitan.

MATLABxlsread mac

Hello Everyone, How are you?

Well, I'm trying to read a Exel file with Missing Values using xlsread, but when I run the code, matlab giving me the following error

[NUM,TXT,RAW]=xlsread('001.xls','B6:F100')
Warning: Range cannot be used in 'basic' mode.  The entire sheet will be loaded. 
> In xlsread (line 204) 
Error using xlsread (line 251)
File contains unexpected record length.  Try saving as Excel 98.

Does anybody have any idea what the problem is here?,

I really appreciate any help.

Thanks

Best Answer

That is not an .xls file, and it is not an .xlsx file or a .xml file either. It is a plain HTML file. You can use Excel to Save As a .xslx file that can then be read by MATLAB.

Related Solutions

MATLAB: Protect Excel Sheet in MATLAB

   xlsprotect(file,'protect_file',pwd2open,pwd2modify,read_only_recommended,create_backup)
 xlsprotect(file,'unprotect_file',pwd2open) 
 xlsprotect(file,'unprotect_file',pwd2open,pwd2modify)
 xlsprotect(file,'protect_sheet',sheetname,password) 
 xlsprotect(file,'protect_sheet',sheetname,password,s_options) 
 xlsprotect(file,'protect_sheet',sheetname,s_options) 
 xlsprotect(file,'protect_sheet',sheetname)
 xlsprotect(file,'unprotect_sheet',sheetname) 
 xlsprotect(file,'unprotect_sheet',sheetname,password)
 xlsprotect(file,'protect_workbook',password) 
 xlsprotect(file,'protect_workbook')
 xlsprotect(file,'unprotect_workbook') 
 xlsprotect(file,'unprotect_workbook',password)

MATLAB: Excel Range in specifies Sheet.

Hi, Just activating the particular sheet before adding range will solve it.

ex = actxserver('excel.application');

ex.Workbooks.Open(fullfile(pwd,'XXXXXXX.xlsx'));

Sheets = Excel.ActiveWorkBook.Sheets;

Sheet3 = get(Sheets, 'Item', 'Sheet3');

Sheet3.Activate

ex.Range('A3').Name = 'RangeName';

ex.ActiveWorkbook.Save

ex.Quit

ex.release

Best Answer

Related Solutions

MATLAB: Protect Excel Sheet in MATLAB

MATLAB: Excel Range in specifies Sheet.

Related Question