Rank: 57426 based on 0 downloads (last 30 days) and 0 files submitted
photo

Stefan

E-mail

Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Comments and Ratings by Stefan View all
Updated File Comments Rating
02 Feb 2010 Load Open Document Spreadsheets Loads a spreadsheet in the open document format (used by programs like Open Office) into a cell arra Author: Alex Marten

OK, submitting a new file was not a good idea. Here are my changed lines:

23 function data = loadods_2010_02_02(filepath,filename,options)

26 if nargin<3, options = []; end

31 if exist([filepath filename])~=2

42 unzip([filepath filename],dir_temp);

Note: the filename of the tool must be loadods_2010_02_02.m or change line 23

02 Feb 2010 Load Open Document Spreadsheets Loads a spreadsheet in the open document format (used by programs like Open Office) into a cell arra Author: Alex Marten

Thank for the tool. Now I don't have to use microsoft excel.
Seems to be working on matlab 6.5 R13, too. But there is an issue using filenames containing a complete path (like c:\myfiles\testfile.ods). The line 36 'if ~mkdir(tempdir,filename) fails and the result is 'permission error'. My solution: separating path and filename: loadods(filepath, filename, options).
There are some necessary changes in the lines 23, 26, 31 and 42. I'll try to upload my version (loadods_2010_02_02.m).

Contact us at files@mathworks.com