Reading xls(x)-files into Octave

[Per-Olof Sturesson]

Hello,

 

I would like to read in data from an xls(x)-file into Octave.

I run Octave ver 3.2.4 on Win XP.

 

I have installed the io package. When using 'xlsopen('file.xls')' I get this error message:

>>> xls=xlsopen('file.xls')

Supported interfaces:

warning: No support for Excel .xls I/O

xls = [](0x0)

I have tried to install java package but when opening with 'xlsopen('file.xls',0,'POI') I receive:

>>> xls=xlsopen('5thgear.xls',0,'POI')

Java/Apache POI interface requested... >>>error: ...but that's not supported!

error: called from:

error: C:\MyPrograms\Octave\3.2.4_gcc-4.4.0\share\octave\packages\io-1.0.13\x

lsopen.m at line 104, column 1

 

I have succeded to install the java package. Here is screen print:

pkg install java-1.2.7.tar.gz -verbose

mkdir (C:\DOCUME~1\fznlnj\LOCALS~1\Temp\oct-2)

untar (java-1.2.7.tar.gz, C:\DOCUME~1\fznlnj\LOCALS~1\Temp\oct-2)

checking for gcc... mingw32-gcc-4.4.0-dw2

checking whether the C compiler works... yes

checking for C compiler default output file name... a.exe

checking for suffix of executables... .exe

checking whether we are cross compiling... no

checking for suffix of object files... o

checking whether we are using the GNU C compiler... yes

checking whether mingw32-gcc-4.4.0-dw2 accepts -g... yes

checking for mingw32-gcc-4.4.0-dw2 option to accept ISO C89... none needed

checking for mkoctfile... mkoctfile

retrieving compile and link flags from mkoctfile

checking for F77_FUNC... yes

checking for octave... octave

checking for OCTAVE_VERSION in Octave... 3.2.4

checking for octave_config_info('canonical_host_type') in Octave... i686-pc-min

gw32

checking for octave_config_info('SHLEXT') in Octave... dll

checking whether ln -s works... yes

checking for ranlib... ranlib

checking for strip... strip

checking for java... java

checking for javac... no

checking for jar... no

configure: creating ./config.status

config.status: creating Makeconf

  "$prefix" is C:/MyPrograms/Octave/3.2.4_gcc-4.4.0/share/octave/packages/java-

1.2.7

  "$exec_prefix" is ${prefix}

octave commands will install into the following directories:

   m-files:   /usr/local/octmgw32_gcc-4.4.0-dw2/octave/3.2.4-4/share/octave/3.2

.4/site/m/octave-forge

   oct-files: /usr/local/octmgw32_gcc-4.4.0-dw2/octave/3.2.4-4/libexec/octave/3

.2.4/site/oct/i686-pc-mingw32/octave-forge

   binaries:  /usr/local/octmgw32_gcc-4.4.0-dw2/octave/3.2.4-4/libexec/octave/3

.2.4/site/exec/i686-pc-mingw32

alternatives:

   m-files:   /usr/local/octmgw32_gcc-4.4.0-dw2/octave/3.2.4-4/share/octave/3.2

.4/site/octave-forge-alternatives/m

   oct-files: /usr/local/octmgw32_gcc-4.4.0-dw2/octave/3.2.4-4/libexec/octave/3

.2.4/site/octave-forge-alternatives/oct/i686-pc-mingw32

shell commands will install into the following directories:

   binaries:  ${exec_prefix}/bin

   man pages: ${datarootdir}/man

   libraries: ${exec_prefix}/lib

   headers:   ${prefix}/include

octave-forge is configured with

   octave:      octave (version 3.2.4)

   mkoctfile:        mkoctfile for Octave 4

   java:        Java Development Kit not found

find . -name NOINSTALL -print    # shows which toolboxes won't be installed

make: Entering directory `/tmp/oct-2/java-1.2.7/src'

Java support not compiled

make: Leaving directory `/tmp/oct-2/java-1.2.7/src'

 

Any suggestions?

 

POS