Changes

Jump to navigation Jump to search
1 byte added ,  11:53, 19 August 2014
Line 36: Line 36:  
* First open the spreadsheet file using xlsopen (for Excel or gnumeric files) or odsopen (.ods or .gnumeric).  
 
* First open the spreadsheet file using xlsopen (for Excel or gnumeric files) or odsopen (.ods or .gnumeric).  
 
'''NOTE''': the output of these functions is a file pointer handle that you should treat carefully!
 
'''NOTE''': the output of these functions is a file pointer handle that you should treat carefully!
* (for reading data) Read the data using raw_data = xls2oct (fileptr [,sheet#] [,cellrange] [,options])
+
* (for reading data) Read the data using raw_data = xls2oct (<fileptr> [,sheet#] [,cellrange] [,options])
 
* Next, optionally split the data in numerical, text and raw data and optionally get the limits of where these came from:
 
* Next, optionally split the data in numerical, text and raw data and optionally get the limits of where these came from:
 
[num, txt, raw, lims] = parsecell (data, <fileptr.lims>)
 
[num, txt, raw, lims] = parsecell (data, <fileptr.lims>)
 
* (for writing data) Write the data using <fileptr> = oct2xls (data, <fileptr> [,sheet#] [,cellrange] [,options])
 
* (for writing data) Write the data using <fileptr> = oct2xls (data, <fileptr> [,sheet#] [,cellrange] [,options])
* When you're finished, DO NOT FORGET to colse the file pointer handle:
+
* When you're finished, DO NOT FORGET to close the file pointer handle:
 
<fileptr> = xlsclose (<fileptr>)</pre>
 
<fileptr> = xlsclose (<fileptr>)</pre>
   Line 47: Line 47:     
Obviously this is much more flexible (and FASTER) than xlsread and xlswrite. In fact, Octave's io package xlsread is a mere wrapper for an xlsopen-xls2oct-parsecell-xlsclose sequence. Similarly for xlswrite, odsread, and odswrite.
 
Obviously this is much more flexible (and FASTER) than xlsread and xlswrite. In fact, Octave's io package xlsread is a mere wrapper for an xlsopen-xls2oct-parsecell-xlsclose sequence. Similarly for xlswrite, odsread, and odswrite.
      
==== .xls ~= .xlsx ====
 
==== .xls ~= .xlsx ====
Anonymous user

Navigation menu