Hi Philip,
I get:
octave:1> chk_spreadsheet_support([],3)
Checking Excel/ActiveX/COM... OK.
Checking Java support...
1. Checking Java JRE presence.... OK, found one.
2. Checking Octave Java support... Java package seems to work OK.
Java (version 1.6.0_29) seems OK.
Maximum JVM memory: 495 MiB; sufficient.
Java support OK
Checking javaclasspath for .jar class libraries needed for spreadsheet
I/O...:
Basic POI (.xls) <poi-3> <poi-ooxml>:
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\poi-3.7-20101029.jar OK
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\poi-ooxml-3.7-20101029.jar OK
=> Apache (POI) OK
POI OOXML (.xlsx) <xbean> <poi-ooxml-schemas> <dom4j>:
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\xbean.jar OK
-
C:\Octave\Octave3.4.3_gcc4.5.2\bin\poi-ooxml-schemas-3.7-20101029.jar OK
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\dom4j-1.6.1.jar OK
=> POI OOXML OK
JExcelAPI (.xls (incl. BIFF5 read)) <jxl>:
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\jxl.jar OK
=> Java/JExcelAPI (JXL) OK.
OpenXLS (.xls (BIFF8)) <OpenXLS>:
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\OpenXLS-6.0.6.jar OK
=> Java/OpenXLS (OXS) OK.
ODF Toolkit (.ods) <odfdom> <xercesImpl>:
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\odfdom-java-0.8.7.jar OK
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\xercesImpl-2.9.1.jar OK
=> ODFtoolkit (OTK) OK.
jOpenDocument (.ods + experimental .sxc readonly) <jOpendocument>:
- C:\Octave\Octave3.4.3_gcc4.5.2\bin\jOpenDocument-1.2.jar OK
=> jOpenDocument (JOD) OK.
UNO/Java (.ods, .xls, .xlsx, .sxc) <OpenOffice.org>:
program.... (directory) not found
unoil....jar missing
jurt....jar missing
juh....jar missing
unoloader....jar missing
ridl....jar missing
=> One or more UNO classes (.jar) missing in javaclasspath
All interfaces already fully supported.
ans = 127
octave:2>
So, I think my POI version is 3.7.
With kind regards,
Martin
On 11/19/2011 7:45 PM, Philip Nienhuis wrote:
Martin Hoeijmakers wrote:
Hi Philip,
Thank you for your quick response. Your solution was simple and works
well.
However, I met another problem. Because I am not sure about the cause, I
didn't cc to the developers list.
Sure, I understand, nevertheless, please always cc the OctDev ML.
There may be (many?) "lurkers" with the same or similar problems who
may recognize your problem and be helped with the discussion.
By posting and discussion, a sort of "knowledge base" is easily built up.
Because I use my program on two systems - one without Excel - I used POI
(with Octave 3.2.4). If I use POI now, I get the error message
error: [java] java.lang.NoSuchMethodException: getNumWorkSheets
error: called from:
error:
C:\Octave\Octave3.4.3_gcc4.5.2\share\octave\packages\io-1.0.15\oct2xls.m
at line 491, column 14
error:
C:\Octave\Octave3.4.3_gcc4.5.2\share\octave\packages\io-1.0.15\oct2xls.m
at line 163, column 17
Do you have a solution for this?
Looks like you have something mixed up in the Apache POI Java class libs.
Please run this command:
chk_spreadsheet_support ('', 3)
('' = 2 consecutive quotes, w/o space in between, and NO ";" at the end)
and copy the output in your reply.
Do you know the POI version? (3.5, 3.6, 3.7, 3.8?)
I need this info to be able to help you solve this issue.
Philip
------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure
contains a definitive record of customers, application performance,
security threats, fraudulent activity, and more. Splunk takes this
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Octave-dev mailing list
Octave-dev@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/octave-dev
