Menu
▾
▴
[Octave-cvsupdate] SF.net SVN: octave:[6978] trunk/octave-forge/main/io/doc
|
From: <prn...@us...> - 2010-03-01 15:41:46
|
Revision: 6978
http://octave.svn.sourceforge.net/octave/?rev=6978&view=rev
Author: prnienhuis
Date: 2010-03-01 15:41:38 +0000 (Mon, 01 Mar 2010)
Log Message:
-----------
Adapted javaclasspath requirements (rt.jar not needed)
Modified Paths:
--------------
trunk/octave-forge/main/io/doc/READ-ODS.html
trunk/octave-forge/main/io/doc/READ-XLS.html
Modified: trunk/octave-forge/main/io/doc/READ-ODS.html
===================================================================
--- trunk/octave-forge/main/io/doc/READ-ODS.html 2010-03-01 15:31:40 UTC (rev 6977)
+++ trunk/octave-forge/main/io/doc/READ-ODS.html 2010-03-01 15:41:38 UTC (rev 6978)
@@ -3,11 +3,11 @@
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
<TITLE></TITLE>
- <META NAME="GENERATOR" CONTENT="OpenOffice.org 3.0 (Win32)">
+ <META NAME="GENERATOR" CONTENT="OpenOffice.org 3.2 (Win32)">
<META NAME="AUTHOR" CONTENT="Philip Nienhuis">
<META NAME="CREATED" CONTENT="20091229;22213000">
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
- <META NAME="CHANGED" CONTENT="20100118;21551300">
+ <META NAME="CHANGED" CONTENT="20100301;16382300">
<META NAME="Info 1" CONTENT="">
<META NAME="Info 2" CONTENT="">
<META NAME="Info 3" CONTENT="">
@@ -16,160 +16,158 @@
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
+ <META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
<STYLE TYPE="text/css">
<!--
- @page { margin: 0.79in }
- P { margin-bottom: 0.08in }
+ @page { margin: 2.01cm }
+ P { margin-bottom: 0.2cm }
A:link { so-language: zxx }
-->
</STYLE>
</HEAD>
<BODY LANG="en-US" DIR="LTR">
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><U><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 16pt"><B>ODS
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><U><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 16pt"><B>ODS
support for Octave</B></U></FONT></FONT></P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Copyright
-© 2009 Philip Nienhuis <prnienhuis at users.sf.net></FONT></FONT></P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2>Copyright
+© 2009, 2010 Philip Nienhuis <prnienhuis at users.sf.net></FONT></FONT></P>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2>This
-version January 18, 2010</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2>This
+version March 1, 2010</FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I>(ODS
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I>(ODS
= Open Document Format spreadsheet data format, used by e.g.,
OpenOffice.org.)</I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Files
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><U><B>Files
content</B></U></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 1.98in; text-indent: -1.98in; margin-bottom: 0in">
+<P ALIGN=LEFT STYLE="margin-left: 5.03cm; text-indent: -5.03cm; margin-bottom: 0cm">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>odsread.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">No-hassle
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">No-hassle
read script for reading from an ODS file and parsing the numeric and
text data into separate arrays.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 1.98in; text-indent: -1.98in; margin-bottom: 0in">
+<P ALIGN=LEFT STYLE="margin-left: 5.03cm; text-indent: -5.03cm; margin-bottom: 0cm">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>odswrite.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">No-hassle
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">No-hassle
write script for writing to an ODS file.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 1.98in; text-indent: -1.98in; margin-bottom: 0in">
+<P ALIGN=LEFT STYLE="margin-left: 5.03cm; text-indent: -5.03cm; margin-bottom: 0cm">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>odsopen.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 1.98in; text-indent: -1.98in; margin-bottom: 0in">
+<P ALIGN=LEFT STYLE="margin-left: 5.03cm; text-indent: -5.03cm; margin-bottom: 0cm">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Get
a file pointer to an ODS spreadsheet file.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>ods2oct.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Read
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>ods2oct.m</B></I></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Read
raw data from an ODS spreadsheet file using the file pointer handed
by odsopen.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>oct2ods.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Write
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>oct2ods.m</B></I></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Write
data to an ODS spreadsheet file using the file pointer handed by
odsopen.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>odsclose.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Close
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>odsclose.m</B></I></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Close
file handle made by odsopen and -if data have been transfered to a
spreadsheet- save data.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>odsfinfo.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Explore
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>odsfinfo.m</B></I></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Explore
sheet names and optionally estimated data size of ods files with
unknown content.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>calccelladdress.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Utility
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>calccelladdress.m</B></I></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Utility
function needed for jOpenDocument class.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>parsecell.m</B></I></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">(contained
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><I><B>parsecell.m</B></I></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">(contained
in Excel xlsread scripts, but works also for ods support) parse raw
data (cell array) into separate numeric array and text (cell) array.)</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>REQUIRED
+<P ALIGN=CENTER STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>REQUIRED
SUPPORT SOFTWARE</B></U></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-left: 1.98in; text-indent: -1.98in; margin-bottom: 0in">
+<P ALIGN=LEFT STYLE="margin-left: 5.03cm; text-indent: -5.03cm; margin-bottom: 0cm">
<BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 1.98in; text-indent: -1.98in; margin-bottom: 0in">
+<P ALIGN=LEFT STYLE="margin-left: 5.03cm; text-indent: -5.03cm; margin-bottom: 0cm">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">For
Windows (MingW):</FONT></FONT></P>
<UL>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave
with java package (>= 1.2.6)</FONT></FONT></P>
</UL>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">For
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">For
Linux:</FONT></FONT></P>
<UL>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave
with java package (>= 1.2.5; earlier versions not tested)</FONT></FONT></P>
</UL>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">For
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">For
ODS access, you'll need to choose at least one of the following java
class files collections:</FONT></FONT></P>
<UL>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">(currently
- the preferred option) <B>odfdom.jar</B> & <B>xercesImpl.jar</B>.
- Get them here:</FONT></FONT></P>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in"><A HREF="http://odftoolkit.org/projects/odfdom/downloads/directory/current-version"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">http://odftoolkit.org/projects/odfdom/downloads/directory/current-version</FONT></FONT></A></P>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in"><A HREF="http://xerces.apache.org/mirrors.cgi"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">http://xerces.apache.org/mirrors.cgi</FONT></FONT></A></P>
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">(currently
+ the preferred option) <B>odfdom.jar</B> (only version 0.7.5 works
+ OK!) & <B>xercesImpl.jar</B>. Get them here:</FONT></FONT></P>
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm"><A HREF="http://odftoolkit.org/projects/odfdom/downloads/directory/previous-versions%252Freleases"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">http://odftoolkit.org/projects/odfdom/downloads/directory/previous-versions%252Freleases</FONT></FONT></A></P>
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm"><A HREF="http://xerces.apache.org/mirrors.cgi"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">http://xerces.apache.org/mirrors.cgi</FONT></FONT></A></P>
</UL>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">and/or</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">and/or</FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
<UL>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>jopendocument</B></FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal"><version></SPAN></FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>.jar</B></FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">.
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>jopendocument</B></FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal"><version></SPAN></FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>.jar</B></FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">.
Get it from <A HREF="http://www.jopendocument.org/">http://www.jopendocument.org</A></FONT></FONT></P>
</UL>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
<UL>
- <P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">These,
- plus the </FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>rt.jar</B></FONT></FONT>
- <FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">from
- your local java installation (jre or jdk) must be referenced with
- full pathnames in your javaclasspath. Hint: add it in
- ./share/octave/<version>/m/startup/octaverc using appropriate
- javaaddpath statements.</SPAN></FONT></FONT></P>
+ <P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">These</FONT></FONT><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">
+ must be referenced with full pathnames in your javaclasspath. Hint:
+ add it in ./share/octave/<version>/m/startup/octaverc using
+ appropriate javaaddpath statements.</SPAN></FONT></FONT></P>
</UL>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>USAGE</B></U></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>USAGE</B></U></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">(see
“help ods<function_filename>” in octave terminal.)</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>odsread</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>odsread</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none">
</SPAN><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">is
a sort of analog to xlsread and works more or less the same. </SPAN></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>odsread
</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">is
@@ -179,25 +177,25 @@
that do file access and the actual reading, plus </SPAN></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>parsecell</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none">
</SPAN><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">for
post-processing.</SPAN></FONT></FONT></SPAN></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>odswrite</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>odswrite</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none">
</SPAN><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">works
similar to xlswrite. It too is a wrapper for scripts which do the
actual work and invoke other scripts.</SPAN></FONT></FONT></SPAN></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>odsfinfo</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>odsfinfo</B></FONT></FONT></SPAN><SPAN STYLE="text-decoration: none">
</SPAN><SPAN STYLE="text-decoration: none"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">can
be used to explore odsfiles with unknown content for sheet names and
to get an impression of the data content sizes.</SPAN></FONT></FONT></SPAN></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">When
you need data from just one sheet, odsread is for you. </FONT></FONT>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">But
when you need data from multiple sheets in the same spreadsheet file,
or if you want to process spreadsheet data by limited-size chunks at
@@ -205,59 +203,59 @@
sequences provides for much more speed and flexibility as the
spreadsheet needs to be read just once rather than repeatedly for
each call to odsread.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Same
reasoning goes for odswrite.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Also,
if you use odsopen / …../, you can process multiple
spreadsheets simultaneously – just use odsopen repeatedly to
get multiple spreadsheet file pointers.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Moreover,
after adding data to an existing spreadsheet file, you can fiddle
with the filename in the ods file pointer struct to save the data
into another, possibly new spreadsheet file.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">If
you use odsopen / ods2oct / … / odsclose, DO NOT FORGET to
invoke odsclose in the end. The file pointers can contain an enormous
amount of data and may needlessly keep precious memory allocated.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>GOTCHAS</B></U></FONT></FONT></P>
-<P ALIGN=CENTER STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>GOTCHAS</B></U></FONT></FONT></P>
+<P ALIGN=CENTER STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">I
know of one big gotcha: i.e. reading dates (& time). A less
obvious one is java memory pool allocation size.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>Date
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>Date
and time in ODS</B></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Octave
(as does Matlab) stores dates as a number representing the number of
days since January 1, 0 (and as an aside ignores a.o. Pope Gregorius'
intervention in 1582 when 10 days were simply skipped).</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">OpenOffice.org
stores dates as text strings like “yyyy-mm-dd”.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">MS-Excel
stores dates as a number representing the number of days since
January 1, 1900 (and as an aside, erroneously assumes 1900 to be a
leap year).</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Now,
converting OpenOffice.org date cell values into Octave looks pretty
straightforward. But when the ODS spreadsheet was originally an Excel
@@ -265,27 +263,27 @@
OOo date values (i.e.,strings) OR old numerical values from the Excel
spreadsheet. </FONT></FONT>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">So:
you should carefully check what happens to date cells.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">As
octave has no ”date” or “time” data type,
octave date values (usually numerical data) are simply transferred as
“floats” to ODS spreadsheets. You'll have to convert the
values into dates yourself from within OpenOffice.org.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">While
adding data and time values has been implemented in the write
scripts, the wait is for clever solutions to distinguish dates from
floats in octave cell arrays.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>Java
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><B>Java
memory pool allocation size</B></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">The
java virtual machine (JVM) initializes one big chunk of your
computer's RAM in which all java classes and methods etc. are to be
@@ -295,89 +293,87 @@
Linux this allocated size is much bigger. This part of memory is
where the java-based ODS octave routines (and the java-based xls
routines) live and keep their variables etc.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">For
transferring large pieces of information to and from spreadsheets you
might hit the limits of this pool. E.g. to be able to handle I/O of
an array of around 50,000 cells I needed a memory pool size of 512
MB.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">The
memory size can be increased by inserting a file called “java.opts”
(without quotes) in the directory
./share/octave/packages/java-<version> (where the script file
javaclasspath.m is located), containing just the following lines:</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; text-decoration: none"><FONT FACE="Courier New, monospace"><FONT SIZE=2 STYLE="font-size: 11pt"><B>-Xms16m</B></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; text-decoration: none"><FONT FACE="Courier New, monospace"><FONT SIZE=2 STYLE="font-size: 11pt"><B>-Xmx512m</B></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; text-decoration: none"><FONT FACE="Courier New, monospace"><FONT SIZE=2 STYLE="font-size: 11pt"><B>-Xms16m</B></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; text-decoration: none"><FONT FACE="Courier New, monospace"><FONT SIZE=2 STYLE="font-size: 11pt"><B>-Xmx512m</B></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">(where
16 = initial size, 512 = maximum size, m stands for Megabyte).</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">After
processing a large chunk of spreadsheet information you might notice
that octave's memory footprint does not shrink so it looks like
java's memory pool does not shrink back; but rest assured, the memory
-footprint is the <I>allocated</I><SPAN STYLE="font-style: normal">
-(reserved) memory size, not the actual used size. After the JVM has
-done its garbage collection, only the so-called “working set”
-of the memory allocation is really in use and that is a trimmed-down
+footprint is the <I>allocated</I> <SPAN STYLE="font-style: normal">(reserved)
+memory size, not the actual used size. After the JVM has done its
+garbage collection, only the so-called “working set” of
+the memory allocation is really in use and that is a trimmed-down
part of the memory allocation pool. On Windows systems it often
suffices to minimize the octave terminal for a few seconds to get a
more reasonable memory footprint.</SPAN></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
-<BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
-<BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Smaller
gotcha's (only with jOpenDocument):</FONT></FONT></P>
<UL>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">While
reading, empty cells are sometimes not skipped but interpreted with
numerical value 0 (zero).</FONT></FONT></P>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">A
valid range MUST be specified, I haven't found a way to discover the
actual occupied rows and columns (jOpenDocument can give the
physical ones (= capacity) but that doesn't help).</FONT></FONT></P>
</UL>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>MATLAB
+<P ALIGN=CENTER STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>MATLAB
COMPATIBILITY</B></U></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">AFAIK
there's no similar functionality in Matlab (yet?).</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">odsread
is fairly function-compatible to xlsread, however.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Same
goes for odswrite, odsfinfo and xlsfinfo – however odsinfo has
better functionality IMO.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>COMPARISON
+<P ALIGN=CENTER STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>COMPARISON
OF INTERFACES</B></U></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">The
ODFtoolkit (& associated xerces) interface is the one that gives
the best (but slow) results at present. However, parsing xml trees
into rectangular arrays is not quite straightforward and the other
way round is a real nightmare; odftoolkit does little to hide the
gory details for the developers.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">While
reading ODS is still OK, writing implies checking whether cells
already exist explicitly (in table:table-cells) or implicitly (in
@@ -387,66 +383,66 @@
rebuilding possibly large parts of the tree in memory - nothing for
the faint-of-heart. And odftoolkit lets you sort it out all by
yourself.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">The
jOpenDocument interface is the most promising, as it does shield the
xml tree details and presents developers something which looks like a
spreadsheet model.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">However,
unfortunately the developers decided to shield essential methods by
making them 'protected' (e.g. the vital getCellType). Extracting
sheet names is not implemented in released versions (yet).</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">JopenDocument
does support writing, however I couldn't reliably create new
MutableCells beyond column 1 no matter how hard I tried. The
developers gave me hints but I haven't found a final solution yet.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">And
last (but not least) the jOpenDocument developers state that their
development is primarily driven by requests from customers who pay
for support. I do sympathize with this business model but for octave
needs this may hamper progress for a while.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-left: 0.01in; margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>DEVELOPMENT</B></U></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>DEVELOPMENT</B></U></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">As
with the Excel r/w stuff, adding new interfaces should be easy and
straightforward.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Suggestions
for future development:</FONT></FONT></P>
<UL>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Reliable
and easy ODS write support (maybe when jOpenDocument is more mature)</FONT></FONT></P>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; font-weight: normal; text-decoration: none">
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Speeding
up (ODS is 10 X slower than e.g. OOXML !!!). jOpenDocument is
muchfasterbut </FONT></FONT>
</P>
- <LI><P ALIGN=LEFT STYLE="margin-bottom: 0in; text-decoration: none">“<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">Passing
+ <LI><P ALIGN=LEFT STYLE="margin-bottom: 0cm; text-decoration: none">“<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><SPAN STYLE="font-weight: normal">Passing
function handle” a la Matlab's xlsread.</SPAN></FONT></FONT></P>
</UL>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-left: 0.01in; margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=LEFT STYLE="margin-left: 0.02cm; margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Enjoy!</FONT></FONT></P>
-<P STYLE="margin-left: 0.26in; text-indent: -0.26in; margin-bottom: 0in">
+<P STYLE="margin-left: 0.66cm; text-indent: -0.66cm; margin-bottom: 0cm">
<BR>
</P>
-<P ALIGN=CENTER STYLE="margin-left: 0.26in; text-indent: -0.26in; margin-bottom: 0in; font-weight: normal; text-decoration: none">
+<P ALIGN=CENTER STYLE="margin-left: 0.66cm; text-indent: -0.66cm; margin-bottom: 0cm; font-weight: normal; text-decoration: none">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Philip
-Nienhuis, Jan 18, 2010</FONT></FONT></P>
+Nienhuis, Mar 01, 2010</FONT></FONT></P>
</BODY>
</HTML>
\ No newline at end of file
Modified: trunk/octave-forge/main/io/doc/READ-XLS.html
===================================================================
--- trunk/octave-forge/main/io/doc/READ-XLS.html 2010-03-01 15:31:40 UTC (rev 6977)
+++ trunk/octave-forge/main/io/doc/READ-XLS.html 2010-03-01 15:41:38 UTC (rev 6978)
@@ -3,11 +3,11 @@
<HEAD>
<META HTTP-EQUIV="CONTENT-TYPE" CONTENT="text/html; charset=windows-1252">
<TITLE></TITLE>
- <META NAME="GENERATOR" CONTENT="OpenOffice.org 3.0 (Win32)">
+ <META NAME="GENERATOR" CONTENT="OpenOffice.org 3.2 (Win32)">
<META NAME="AUTHOR" CONTENT="Philip Nienhuis">
<META NAME="CREATED" CONTENT="20091211;17230700">
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
- <META NAME="CHANGED" CONTENT="20100118;21550000">
+ <META NAME="CHANGED" CONTENT="20100301;16403500">
<META NAME="Info 1" CONTENT="">
<META NAME="Info 2" CONTENT="">
<META NAME="Info 3" CONTENT="">
@@ -19,46 +19,47 @@
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
<META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
+ <META NAME="CHANGEDBY" CONTENT="Philip Nienhuis">
<STYLE TYPE="text/css">
<!--
- @page { margin: 0.79in }
- P { margin-bottom: 0.08in }
+ @page { margin: 2.01cm }
+ P { margin-bottom: 0.2cm }
A:link { so-language: zxx }
-->
</STYLE>
</HEAD>
<BODY LANG="en-US" DIR="LTR">
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">README
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">README
for Excel spreadsheet file r/w access scripts for octave (>
-3.2.0)<BR><BR>Copyright (C) 2009, Philip Nienhuis <prnienhuis at
-users.sf.net><BR><BR>This version 18 January 2010.</FONT></FONT></P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
+3.2.0)<BR><BR>Copyright (C) 2009, 2010 Philip Nienhuis <prnienhuis
+at users.sf.net><BR><BR>This version 1 March 2010.</FONT></FONT></P>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>EXCEL
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>EXCEL
.XLS SUPPORT FILES</B></U></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>doc/README-XLS.html</B></FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">This
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>doc/README-XLS.html</B></FONT></FONT></P>
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">This
file.</FONT></FONT></P>
-<P ALIGN=LEFT STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>xlsread.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">All-in-one
+<P ALIGN=LEFT STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>xlsread.m</B></FONT></FONT></P>
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">All-in-one
function for reading data from one specific worksheet in an Excel
spreadsheet file. This script has Matlab-compatible
functionality.<BR><BR><B>xlswrite.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">All-in-one
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">All-in-one
function for writing data to one specific worksheet in an Excel
spreadsheet file. This script has Matlab-compatible functionality.
<BR><BR><B>xlsfinfo.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">All-in-one
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">All-in-one
function for exploring basic properties of an Excel spreadsheet file.
This script has Matlab-compatible functionality.<BR><BR><B>xlsopen.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
for "opening" (= providing a handle to) an Excel
spreadsheet file ("workbook"). This function sorts out
which interface to use for .xls access (i.e.,COM; Java & Apache
POI; JexcelAPI; etc.), but it's choice can be overridden.<BR><BR><B>xls2oct.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
for reading data from a specific worksheet pointed to in a struct
created by xlsopen.m. xls2oct can be called multiple times
consecutively using the same pointer struct, each time allowing to
@@ -66,86 +67,84 @@
in the form of a 2D heterogeneous cell array that can be parsed by
parsecell.m. xls2oct is a mere wrapper for interface-dependent
scripts that do the actual low-level reading .<BR><BR><B>oct2xls.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
for writing data to a specific worksheet pointed to in a struct
created by xlsopen.m. octxls can be called multiple times
consecutively using the same pointer struct, each time allowing to
write data to different ranges and/or worksheets. oct2xls is a mere
wrapper for interface-dependent scripts that do the actual low-level
writing.<BR><BR><B>xlsclose.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
for closing (the handle to) an Excel workbook. When data have been
written to the workbook oct2xls will write the workbook to disk.
Otherwise, the file pointer is simply closed and possibly used
interfaces for Excel access (COM/ActiveX/Excel.exe) will be shut down
properly.<BR><BR><B>parsecell.m</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Function
for separating the data in raw arrays returned by xls2oct, into
numerical/logical and text (cell) arrays.</FONT></FONT></P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>REQUIRED
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>REQUIRED
SUPPORT SOFTWARE</B></U></FONT></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR>For
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR>For
the Excel/COM interface:</FONT></FONT></P>
<UL>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">A
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">A
windows computer with Excel installed</FONT></FONT></P>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Octave-forge
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Octave-forge
Windows-1.0.8 package WITH LATEST SVN PATCHES APPLIED</FONT></FONT></P>
</UL>
-<P STYLE="margin-left: 0.25in; text-indent: -0.26in; margin-bottom: 0in">
+<P STYLE="margin-left: 0.64cm; text-indent: -0.66cm; margin-bottom: 0cm">
<BR>
</P>
-<P STYLE="margin-left: 0.25in; text-indent: -0.26in; margin-bottom: 0in">
+<P STYLE="margin-left: 0.64cm; text-indent: -0.66cm; margin-bottom: 0cm">
<FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">For
the Java / Apache POI / JExcelAPI interfaces (general):</FONT></FONT></P>
<UL>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave-forge
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave-forge
java-1.2.5 package or later version on Linux</FONT></FONT></P>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave-forge
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">octave-forge
java-1.2.6 with latest svn fixes on Windows/MingW</FONT></FONT></P>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Java
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Java
jre or jdk > 1.6.0 (hasn't been tested with earlier versions)</FONT></FONT></P>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">./jre/lib/rt.jar
- in classpath</FONT></FONT></P>
</UL>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Apache
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Apache
POI specific:</FONT></FONT></P>
<UL>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">class
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">class
.jars: <B>poi-3.5-FINAL-<date>.jar</B> &
<B>poi-ooxml-3.5-FINAL-<date>.jar</B> (or later versions) in
classpath</FONT></FONT></P>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Get
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Get
it here: <A HREF="http://poi.apache.org/download.html">http://poi.apache.org/download.html</A></FONT></FONT></P>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">for
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">for
OOXML support (only available with Apache POI): </FONT></FONT>
</P>
- <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">poi-ooxml-schemas-<version>.jar,
+ <P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">poi-ooxml-schemas-<version>.jar,
xbean.jar, dom4j-1.6.1.jar in javaclasspath. </FONT></FONT>
</P>
- <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Get
+ <P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Get
them here:</FONT></FONT></P>
- <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><A HREF="http://poi.apache.org/download.html">http://poi.apache.org/download.html</A>
+ <P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><A HREF="http://poi.apache.org/download.html">http://poi.apache.org/download.html</A>
(“xmlbeans” and poi-ooxml-schemas)</FONT></FONT></P>
- <P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><A HREF="http://sourceforge.net/projects/dom4j/files">http://sourceforge.net/projects/dom4j/files</A>
+ <P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><A HREF="http://sourceforge.net/projects/dom4j/files">http://sourceforge.net/projects/dom4j/files</A>
(dom4j-<version>)</FONT></FONT></P>
</UL>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">JExcelAPI
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">JExcelAPI
specific:</FONT></FONT></P>
<UL>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">class
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">class
.jar: <B>jxl.jar</B> in classpath</FONT></FONT></P>
- <LI><P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Get
+ <LI><P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Get
it here: <A HREF="http://sourceforge.net/projects/jexcelapi/files/">http://sourceforge.net/projects/jexcelapi/files/</A></FONT></FONT></P>
</UL>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Hint:
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">Hint:
simply put the relevant javaaddpath statements in the .octaverc file.</FONT></FONT></P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><BR>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>USAGE</B></U></FONT></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>xlsread</B>
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>USAGE</B></U></FONT></FONT></FONT></P>
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>xlsread</B>
and <B>xlswrite</B> are mere wrappers for
<B>xlsopen</B>-<B>xls2oct</B>-<B>xlsclose</B>-<B>parsecell</B> and
<B>xlsopen</B>-<B>oct2xls</B>-<B>xlsclose</B> sequences, resp. They
@@ -186,20 +185,20 @@
<AnotherWorksheet>, <Range>)</B><BR><BR><I># Close the
workbook and write it to disk; then clear the handle</I><BR><B>xlh =
xlsclose (xlh)</B><BR><B>clear xlh</B></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><BR>
+<P STYLE="margin-bottom: 0cm"><BR>
</P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">When
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt">When
not using the COM interface, specify a value of 'POI' for parameter
REQINTF when accessing OOXML files in xlsread, xlswrite, xlsopen,
xlsfinfo (and be sure the complete Apache POI interface is
installed).</FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><BR>
+<P STYLE="margin-bottom: 0cm"><BR>
</P>
-<P STYLE="margin-bottom: 0in"><BR>
+<P STYLE="margin-bottom: 0cm"><BR>
</P>
-<P ALIGN=CENTER STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>MATLAB
+<P ALIGN=CENTER STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=4 STYLE="font-size: 15pt"><U><B>MATLAB
COMPATIBILITY</B></U></FONT></FONT></P>
-<P STYLE="margin-bottom: 0in"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>xlsread</B>,
+<P STYLE="margin-bottom: 0cm"><FONT FACE="Arial, sans-serif"><FONT SIZE=2 STYLE="font-size: 11pt"><BR><B>xlsread</B>,
<B>xlswrite</B> and <B>xlsfinfo</B> are for ...
[truncated message content] |
