Re: xlread in 3.6.0

[Ming Lu]

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.