From: Raphael Aggio on
Rune Allnor <allnor(a)tele.ntnu.no> wrote in message <9cdf75ff-abaa-43e2-ac31-bf6f631cad2c(a)r24g2000yqd.googlegroups.com>...
> On 15 Des, 19:40, "Ainat Rogel" <ai...(a)nmr.mgh.harvard.edu> wrote:
> > Hello,
> >
> > I am trying to read an xls file in a linux (Centos).  Any tips or sujjestions will be helpful.
> >
> > Thanks - Ainat
> >
> > Here is the error:
> >
> > Warning: XLSREAD has limited import functionality on non-Windows platforms
>
> The error message is pretty cler, right?
>
> To spoon-feed: Excel is a proprietary format for microsoft,
> that is developed for windows. There is no reason to expect
> excel files to be portable to, or usable under, other OSes.
>
> Rune

Hi Rune,

xlsread is suppose to work on limited functionality, but it is suppose to work.

Hey Ainat, I am facing the same problem as you. However, it happens with specific sheets only. I am not sure yet, but should be something with the cell format that you have in your excel sheet. I am trying to play around with the different possible formats but with no success yet.

Also, if you convert you .xls to Excel 5.0/95 workbook (.xls) it works perfectly. However, you have the limitation in 255 character per row and about 16.000 rows.

http://support.microsoft.com/kb/179824

If you find something new, please let me know.

Thanks.

Raphael