[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: xlread in 3.6.0
From: |
Ming Lu |
Subject: |
Re: xlread in 3.6.0 |
Date: |
Wed, 7 Mar 2012 11:36:16 -0800 (PST) |
I just installed 3.6.1 from Octave-Forge and got the same error as 3.6.0. My
answer is in the quote part. Thanks for helping.
PhilipNienhuis wrote
>
> Actually this question belongs to the octave-forge mailing list (xlsread
> comes from the octave-forge io package) => cc'd
>
>
>
> Some counter questions:
>
> - What operating system?
> *Windows XP sp3*
> - Are you talking about the very same .xlsm files that were read from OK
> in 3.4.3 but no more in 3.6.0?
> *Yes, exact same xlsm files and exact octave code*
> - Could you please run (in Octave-3.6.0 then):
> chk_spreadsheet_support ('', 3)
> ('' = empty string) to get more diagnostics about what does work and what
> doesn't?
> *
> 3.6.1
> Checking Excel/ActiveX/COM... not working.
>
> 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: 248 MiB; should better be at least 400 MB!
> Hint: adapt setting -Xmx in file "java.opts" (supposed to be here:)
>
> C:\Octave\Octave3.6.1_gcc4.6.2\share\octave\packages\java-<version>\java.opts
> Java support OK
>
> Checking javaclasspath for .jar class libraries needed for spreadsheet
> I/O...:
>
> Basic POI (.xls) <poi-3> <poi-ooxml>:
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\poi-3.jar OK
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\poi-ooxml-3.jar OK
> => Apache (POI) OK
>
> POI OOXML (.xlsx) <xbean> <poi-ooxml-schemas> <dom4j>:
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\xbean.jar OK
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\poi-ooxml-schemas.jar OK
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\dom4j-1.6.1.jar OK
> => POI OOXML OK
>
> JExcelAPI (.xls (incl. BIFF5 read)) <jxl>:
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\jxl.jar OK
> => Java/JExcelAPI (JXL) OK.
>
> OpenXLS (.xls (BIFF8)) <OpenXLS>:
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\OpenXLS.jar OK
> => Java/OpenXLS (OXS) OK.
>
> ODF Toolkit (.ods) <odfdom> <xercesImpl>:
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\odfdom.jar OK
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\xercesImpl.jar OK
> => ODFtoolkit (OTK) OK.
>
> jOpenDocument (.ods + experimental .sxc readonly) <jOpendocument>:
> - C:\Octave\Octave3.6.1_gcc4.6.2\lib\java\jOpenDocument.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.
>
> 3.4.3
> Checking Excel/ActiveX/COM... not working.
>
> 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.
>
> It looks some Jar files were changed.
> *
>
> AFAIK in xlsopen.m (the file that yields the messages) nothing has changed
> lately that could affect handling of OOXML files.
> Here on my box I can read at least .xlsx files as usual with Octave-3.6.0.
> I've never tried .xlsm files (those seem to be macro files?)
> * Yes, xlsm is for files with Macros*
> Philip
>
--
View this message in context:
http://octave.1599824.n4.nabble.com/xlread-in-3-6-0-tp4451557p4454341.html
Sent from the Octave - General mailing list archive at Nabble.com.