Issue with xlswrite using ver 3.4.3

[Per-Olof Sturesson]

Hello,

 

I have issues with writing data to a MS Excel file using POI interface.

 

Here are some simple screen snapshots:

 

GNU Octave, version 3.4.3

Copyright (C) 2011 John W. Eaton and others.

This is free software; see the source code for copying conditions.

There is ABSOLUTELY NO WARRANTY; not even for MERCHANTABILITY or

FITNESS FOR A PARTICULAR PURPOSE.  For details, type `warranty'.

 

Octave was configured for "i686-pc-mingw32".

 

Additional information about Octave is available at http://www.octave.org.

 

Please contribute if you find this software useful.

For more information, visit http://www.octave.org/help-wanted.html

 

Read http://www.octave.org/bugs.html to learn how to submit bug reports.

 

For information about changes from previous versions, type `news'.

 

io PKG_ADD: java classes has been found and added in C:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin

io PKG_ADD: run chk_spreadsheet_support([],3) to view io support

octave:1> xlsfile='test.xls'

xlsfile = test.xls

octave:2> xls=xlsopen(xlsfile,1,'POI');

Checking requested interface(s):

POI (& OOXML)*; (* = active interface)

Creating file test.xls

octave:3> x=[1:10]';

octave:4> xlswrite(xlsfile,x)

Creating file test.xls

Detected interfaces: not working.

POI (& OOXML)*; JXL; OXS; (* = active interface)

error: [java] java.lang.NoSuchMethodException: getNumWorkSheets

error: called from:

error:   C:\MYPROG~1\Octave\OCTAVE~1.2\share\octave\packages\io-1.0.15\oct2xls.m at line 490, column 14

error:   C:\MYPROG~1\Octave\OCTAVE~1.2\share\octave\packages\io-1.0.15\oct2xls.m at line 162, column 17

error:   C:\MYPROG~1\Octave\OCTAVE~1.2\share\octave\packages\io-1.0.15\xlswrite.m at line 161, column 18

octave:4>

 

I can read data from an MS Excel file using xlsread (with POI interface as well):

 

octave:6> xls=xlsopen('XS 104 AT.xlsx',0,'POI');

Checking requested interface(s):

POI (& OOXML)*; (* = active interface)

octave:7> [data,text,raw,lmits]=xlsread('test2.xls','Sheet1’,'A1:B200');

Detected interfaces: not working.

POI (& OOXML)*; JXL; OXS; (* = active interface)

octave:8>

 

The variable data contains valid data.

 

I have installed version 3.4.3 with both io and java packages, which also are loaded. JRE package is installed on computer:

 

octave:10> chk_spreadsheet_support([],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_30) 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:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\poi-3.7-20101029.jar OK

  - C:\MyPrograms\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:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\xbean.jar OK

  - C:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\poi-ooxml-schemas-3.7-20101029

.jar OK

  - C:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\dom4j-1.6.1.jar OK

  => POI OOXML OK

 

JExcelAPI (.xls (incl. BIFF5 read)) <jxl>:

  - C:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\jxl.jar OK

  => Java/JExcelAPI (JXL) OK.

 

OpenXLS (.xls (BIFF8)) <OpenXLS>:

  - C:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\OpenXLS-6.0.6.jar OK

  => Java/OpenXLS (OXS) OK.

 

ODF Toolkit (.ods) <odfdom> <xercesImpl>:

  - C:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\odfdom-java-0.8.7.jar OK

  - C:\MyPrograms\Octave\Octave3.4.3_gcc4.5.2\bin\xercesImpl-2.9.1.jar OK

  => ODFtoolkit (OTK) OK.

 

jOpenDocument (.ods + experimental .sxc readonly) <jOpendocument>:

  - C:\MyPrograms\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.

 

ans =  126

octave:11>

 

Br

 

POS