Re: installing java and apache for using spreadsheet I/O

[Tatsuro MATSUOKA]

----- Original Message -----

> From: Tatsuro MATSUOKA 
> To: tmacchant "help-octave
> Cc: 
> Date: 2014/6/18, Wed 08:53
> Subject: Re: installing java and apache for using spreadsheet I/O
> 
> ----- Original Mssage -----
> 
>>  From: tmacchant 
>>  To: help-octave
>>  Cc: 
>>  Date: 2014/6/18, Wed 08:02
>>  Subject: Re: installing java and apache for using spreadsheet I/O
>> 
>>  Your current condition :windows 8.1, excel2007 and GNU octave 3.6.4 VS2010
>> 
>>  I have tested on windows 8.1, excel2013 and GNU octave 3.6.4 VS2010.
>>  (My win 8.1 PC excel 2013 is installed)
>> 
>>  pkg load io
>>  pkg load windows
>>  a=xlsread('test.xlsx')
>> 
>>  Detected XLS interfaces: COM*; warning: __chk_java_sprt__: some elements in
>>  list
>>  of return values are undefined
>>  warning:  No Java support found (no Java JRE? no Java pkg installed AND
>>  loaded?)
>> 
>> 
>>  a =
>> 
>>     1   2   3
>>     4   5   6
>>     7   8   9
>> 
>>  Without java package loaded, xlsread worked for me though a warning was
>>  appeared.
>> 
>>  I cannot help further because I cannot reproduce your error.
>> 
>>  Information io 1.2.2, java 1.2.9, and windows 1.2.1. (Octave 3.6.4  VS2010
>>  prebuilt packages.)
>> 
> 
> 
> Hello
> I have tested further on octave-3.8.1 on win 7 with excel 2010.
> 
> Octave-forge packages are built with build_packages 
> at C:\octave\Octave-3.8.1\src
> There is no java package.
> octave:3> pkg load io
> octave:4> pkg load windows
> octave:5> a=xlsread('test.xlsx')
> Detected XLS interfaces: COM*; (* = default interface)
> a =
> 
>    1   2   3
>    4   5   6
>    7   8   9
> octave:6> a=xlsread('test.xls')
> a =
> 
>    1   2   3
>    4   5   6
>    7   8   9
> 
> io-2.2.2 and windows 1.2.1 are installed by "build_packages" script.
> 
> xlsread works on both win 7 and 8 and octave 3.6.4 and 3.8.1.
> 
> I do not know what is wrong with you.
According to the http://wiki.octave.org/IO_package,
  
The (new) OCT interface can read (since version 1.2.5) and write (since version 
2.2.0) .xlsx files dependency-free!
No need of MS Windows+Office nor Java.


Prebuild io package for  octave 3.6.4 is 1.2.2 while for octave-3.8.1 (not 
prebuild but build itself is easy[1]) is 2.2.2.

I recommend that you use save excel file as xlsx file not xls and use 
octave-3.8.1 with io-2.2.2.

[1]
At src directory (For typical install it is C:\octave\Octave-3.8.1\src), run 
build_packages script.
You can install some useful octave-forge packages including io-2.2.2.

Tatsuro