Rank: 2481 based on 19 downloads (last 30 days) and 1 file submitted
Personal Profile:
Professional Interests:

 

Watch this Author's files

 

Files Posted by Alex
  • 1 - 1 of
  • 1
Updated   File Tags Downloads
(last 30 days) 		Comments Rating
07 Jul 2009 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 data import, data export, open document spreads... 19 7
  • 4.0
4.0 | 3 ratings
Comments and Ratings on Alex's Files View all
  • 1 - 5 of
  • 9
Updated File Comment by Comments Rating
04 Jul 2011 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 K

Sorry, didn't include the most important part of the error message:

??? Attempt to reference field of non-structure array.

Error in ==> loadods at 57
nodes = node.getChildNodes
04 Jul 2011 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 K

Thank you for developing this very useful function. I was wondering if you could help me with a problem in using it.

When I try to use loadods(), I get the following error:

Error in ==> loadods at 57
nodes = node.getChildNodes

This error comes up even with the simplest ods file (1 sheet, 3 numbers). The temporary file content.xls seems to contain correct information.

Would really appreciate your help with this!

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 Stefan

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 Stefan

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).
30 Oct 2009 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 Ilya
Top Tags Applied by Alex
  • 1 - 3 of
  • 3
data export, data import, open document spreadsheet
Files Tagged by Alex
  • 1 - 1 of
  • 1
Updated   File Tags Downloads
(last 30 days) 		Comments Rating
07 Jul 2009 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 data import, data export, open document spreads... 19 7
  • 4.0
4.0 | 3 ratings

Contact us at files@mathworks.com