Load Open Document Spreadsheets

Loads a spreadsheet in the open document format (used by programs like Open Office) into a cell arra
3.4K Downloads
Updated 7 Jul 2009

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.

Cite As

Alex Marten (2024). Load Open Document Spreadsheets (https://www.mathworks.com/matlabcentral/fileexchange/18222-load-open-document-spreadsheets), MATLAB Central File Exchange. Retrieved .

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

Inspired: Rosin-Rammler Diagram plotting tool

Community Treasure Hunt

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

Start Hunting!
Version Published Release Notes
1.1.0.0

Updated for BSD licensing change

1.0.0.0