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

Question

Javier 2016-7-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/293603-how-to-get-matlab-xlsread-to-read-in-os-x-el-capitan

评论： Javier 2016-7-4

采纳的回答： Walter Roberson

001.xls

在 MATLAB Online 中打开

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Walter Roberson 2016-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/293603-how-to-get-matlab-xlsread-to-read-in-os-x-el-capitan#answer_227583

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.