File Exchange

image thumbnail

Load ods. Import numbers from Open Document Spreadsheet

version 1.0 (2.82 KB) by

Import data from .ods file into cell arrays.



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.

Comments and Ratings (1)

Quan Wang

Quan Wang (view profile)

Very helpful! Exactly what I need. It would be better if it can also load non-number contents.

MATLAB Release
MATLAB 7.9 (R2009b)

Download apps, toolboxes, and other File Exchange content using Add-On Explorer in MATLAB.

» Watch video