Re: Unable to use xlsread function

[PhilipNienhuis]

jf wrote
> I am trying to use the xlsread functionality and it's not working either.
> 
> My operating system is Ubuntu 13.04, and the octave-io version which was
> installed from the official repository was io-1.0.something. It didn't
> work so I installed io-1.2.2 from Octave-Forge (downloaded the tar.gz, ran
> "sudo octave" in the console to have permissions, and inside octave ran
> "pkg install 'io-1.2.2.tar.gz' "). It still did not work. 
> 
> After a few browsing I found this thread, where debatri was experiencing
> error messages which were similar to mine. Running
> "chk_spreadsheet_support ('', 3) " as PhilipNiehuis suggests yields:
> 
>  "
> Checking Excel/ActiveX/COM... not working.
> 
> Checking Java support...
>   1. Checking Java JRE presence.... OK, found one.
>   2. Checking Octave Java support... Java seems to work OK.
>   Java (version 1.7.0_25) seems OK.
> jmem =
> <Java object: java.lang.Long>
>   Maximum JVM memory:   859 MiB; sufficient.
> Java support OK
> 
> Checking javaclasspath for .jar class libraries needed for spreadsheet
> I/O...:
> 
> Basic POI (.xls) 
> <poi-3>
>  
> <poi-ooxml>
> :
>   poi-3....jar missing
>   poi-ooxml-3....jar missing
>   => Not all classes (.jar) required for POI in classpath
> 
> POI OOXML (.xlsx) &lt;xbean/xmlbean&gt; 
> <poi-ooxml-schemas>
>  
> <dom4j>
> :
>   xbean/xmlbean....jar missing
>   poi-ooxml-schemas....jar missing
>   dom4j....jar missing
>   => Some classes for POI OOXML support missing
> 
> JExcelAPI (.xls (incl. BIFF5 read)) 
> <jxl>
> :
>   jxl....jar missing
>   => Not all classes (.jar) required for JXL in classpath
> 
> OpenXLS (.xls (BIFF8)) 
> <OpenXLS>
> :
>   OpenXLS....jar missing
>   => Not all classes (.jar) required for OXS in classpath
> 
> ODF Toolkit (.ods) 
> <odfdom>
>  
> <xercesImpl>
> :
>   odfdom....jar missing
>   xercesImpl....jar missing
>   => Not all required classes (.jar) in classpath for OTK
> 
> jOpenDocument (.ods + experimental .sxc readonly) 
> <jOpendocument>
> :
>   jOpenDocument....jar missing
>   => Not all required classes (.jar) in classpath for JOD
> 
> UNO/Java (.ods, .xls, .xlsx, .sxc) 
> <OpenOffice.org>
> :
>   program....jar missing
>   unoil....jar missing
>   jurt....jar missing
>   juh....jar missing
>   unoloader....jar missing
>   ridl....jar missing
>   => One or more UNO classes (.jar) missing in javaclasspath
> Some class libs lacking yet...
> 
> "  
> So it seems that there are a lot of dependencies missing. Can anyone point
> point out where these can be found? Should I raise this question in a
> Ubuntu forum instead?

All the info you need is on the Octave wiki (did you know we have one?),
look here:

http://wiki.octave.org/IO_package

In the spirit of open source / free SW, ODS support is mentioned first so
scroll down a bit for the XLS stuff.

Now I don't know Ubuntu (I have Mageia running) but I'm a little bit
surprised that Ubuntu doesn't install the required Java class libs as
dependency for you when you install Octave and the io package from the
official repos. (Hmmm... to be honest I should probably wonder if Mageia
does either.)
But then again there are several other functions in the io package that
don't need them.

BTW: the UNO-Java stuff is only needed when you want OpenOffice.org or
LibreOffice to do the work for xlsread. It's still experimental but for
really large spreadsheets it is the fastest option. I think most users go
for Apache POI.

Philip




--
View this message in context: 
http://octave.1599824.n4.nabble.com/Unable-to-use-xlsread-function-tp4654719p4656630.html
Sent from the Octave - General mailing list archive at Nabble.com.