How can I import spreadsheets from OpenOffice Calc?

Is there a way to import spreadsheets from OpenOffice Calc Version 4.0.1 into Matlab Version R2013b. I´ve saved my file als Excel xls and tried xlsread in basic-mode, but an Error occured:

Error using xlsread (line 248)
XLSREAD unable to read sheet 'Spreadsheet2'.
File does not contain recognized Excel data.  Try saving as Excel 98.

Actually the command xlsfinfo says it is an Excel-file. If I use a spreadsheet made with Excel and change it with OpenOffice, it depends on the numbers of spreadsheets in the file how many rows I can import. I don´t use any Toolboxes.

Answer 1

[dpb]

I've not used O-O enough to know what it does about compatibility of files but clearly as far as the Matlab implementation of xlsread with your version it isn't being recognized as being readable in whatever level of Excel compatibility you saved it as. Did you try the suggested workaroud?

If that fails or O-O support doesn't have any compatibility suggestions, it would seem your choices would be to investigate whether a later release of Matlab might have more capability or the generic solution would be to save as a csv file and read it instead.

[Bernd Ruck]

What workaround did you mean?

[dpb]

File does not contain recognized Excel data. Try saving as Excel 98.