image thumbnail

Read and Write Open Document Format (ODF) Spreadsheet (.ods)

version 1.5.0.0 (6.85 KB) by Paul
Wrappers for the matlab xlsread / xlswrite commands that read ODF Spreadsheet files (.ods).

2.8K Downloads

Updated 15 Nov 2013

View License

On a pc the wrapper will simply call xlsread / xlswrite, but on a mac or unix platform will read an Open Document Format (ODF) spreadsheet, for example as saved by Open Office.

The wrapper uses java commands from the ODFDOM project which provides java libraries for reading Open Document Format files. The library is not provided here, to download see:

http://incubator.apache.org/odftoolkit/

Once the odfdom.jar file is download it must be added to the javaclasspath (see Matlab documentation on importing java libraries).

This wrapper was developed and tested only on a Mac platform (OSX 10.6.4) with Matlab 2010b using ODFDOM version 0.8.6 (only slight testing with 0.8.7), but should work on other platforms. It could be easily modified to read .ods on a pc or accept variable number of input arguments as xlsread does (currently all xlsread inputs must be specified).

Cite As

Paul (2021). Read and Write Open Document Format (ODF) Spreadsheet (.ods) (https://www.mathworks.com/matlabcentral/fileexchange/28411-read-and-write-open-document-format-odf-spreadsheet-ods), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2010b
Compatible with any release
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!