From: Paul on

>
> Hi All,
>
> Here is what I sent to Mathwork:
> ===========================================
> Title: Read/Write OpenDocument Spreadsheet files (.ods)
>
> Matlab can conveniently read and write Excel files.
> Non-Windows operating systems, however, don't have Excel, hence this convenient feature is useless.
> On the other hand, all operating systems have OpenOffice application. OpenOffice uses the OpenDocument ISO standard with file name extension .ods.
> Many other applications read and write .ods files on various of operating systems and platforms.
>
> Matlab, that runs on non-Windows operating systems, did not implement a read/write function from/to .ods files.
> We ask this feature to be implemented.
>
> For developers:
> A starting point could be odftoolkit.org
> or jopendocument.org: [http://www.jopendocument.org/start_spreadsheet_2.html]
> ===========================================
>
> Feel free to send similar messages too.
> You'll have to go to
> http://www.mathworks.com/support/service_requests/contact_support.do
>
> and fill in the details.
>
> good luck.

I took this advice and utilized the ODFDOM library (part of the odftoolkit project) to implement an xlsread wrapper .m function that will read .ods files on a non-pc platform. The function imports and utilizes classes from the odfdom.jar library.

http://www.mathworks.com/matlabcentral/fileexchange/28411

Currently it requires all of the arguments to xlsread (same arguments) and calls the regular xlsread for .xls files on a pc, but these can easily be modified. You can download and read documentation for the ODFDOM library at:

http://odftoolkit.org/projects/odfdom/pages/Home
From: Yuval Aviel on
"Paul " <elhuh(a)hotmail.com> wrote in message <i3pmb0$6c6$1(a)fred.mathworks.com>...
>
> I took this advice and utilized the ODFDOM library (part of the odftoolkit project) to implement an xlsread wrapper .m function that will read .ods files on a non-pc platform. The function imports and utilizes classes from the odfdom.jar library.
>
> http://www.mathworks.com/matlabcentral/fileexchange/28411
>
Thanks, Paul.

It looks great.

Yuval.