Load ods. Import numbers from Open Document Spreadsheet

Import data from .ods file into cell arrays.
1.1K Downloads
Updated 26 Dec 2012

View License

The function provides a simple method with which one can load the contents of open document spreadsheets into MATLAB. Allowing users to directly import files created by Open Office into MATLAB.

Provided with the filename of the spreadsheet the function will import the contents into a MATLAB cell array. The function handles the presence of multiple worksheets by allowing the user to specify a particular worksheet to import.

The function has not undergone rigorous testing, but it has worked for all of my needs. Also, I think a similar method may be implemented to allow one to export data from MATLAB into open document spreadsheets.
Based on Alex Marten methods.

Cite As

Antonio Quarta (2024). Load ods. Import numbers from Open Document Spreadsheet (https://www.mathworks.com/matlabcentral/fileexchange/39592-load-ods-import-numbers-from-open-document-spreadsheet), MATLAB Central File Exchange. Retrieved .

MATLAB Release Compatibility
Created with R2009b
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!
Version Published Release Notes
1.0.0.0