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

1 次查看（过去 30 天）
Javier
Javier 2016-7-4
评论： Javier 2016-7-4
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

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

采纳的回答

Walter Roberson
Walter Roberson 2016-7-4
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by