xlsread UNIX

Hello, I am using xlsread (in basic mode) in UNIX and I get this error: unrecognized header. Apparently it is a common error and there is no workaround. Well, I am still hoping someone could fix it...

Answer 1

[Jan]

As far as I understand when reading help xlsread, you can Excel files in basic mode only under Linux. This means, that the "Excel" file must actually be a tab-separated text file or a "compatible with Excel 97-2003". Do you try to process a binary Excel file? Perhaps a XLSX file?

Answer 2

[Fanny Vatter Pelissier]

Thanks you for your answer. Actually, it seems that xlsread can read my file, except one header (it is written 'prot'). We tried to change it in anything, and it does not work. Apparently it is a common error...

Answer 3

[Abhijit]

Hi

I cannot read xlsx file in UNIX platform. Could you please post what you did to read the xlsx file. I dont care about the header

[Fanny]

What is your problem exactly? What is the error message?

[Abhijit]

 I am trying to read a xlsx file in linux platform. I am using xlsread with basic and sheet name as string. MATLAB R2007 / R2008a version.  I get the following error msg

> In xlsread at 198 ??? Error using ==> xlsread at 211 File contains unexpected record length. Try saving as Excel 98.

[Walter Roberson]

It cannot be done in R2007 / R2008 MATLAB on Linux, except by writing code yourself to do it.