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

2 vues (au cours des 30 derniers jours)
Javier
Javier le 4 Juil 2016
Commenté : Javier le 4 Juil 2016
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

Réponse acceptée

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

Plus de réponses (0)

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by