Octave 4.2.0 io 2.4.5 windows 7 excel .xlsx

[Theresa Arndt]

Hi there,

I have troubles reading my script which I created with Octave 3.8.1. It worked fine only with the packages io and windows. I'm sorry if I ask any stupid questions because I'm a newby to Octave....

After installing Octave 4.2.0 on a windows 7 (german) computer, it seems that the xlsread command doesn't work anymore.

here is a list of the packages after using the command >>pkg rebuild:
>> pkg list
Package Name         | Version | Installation directory
---------------------+---------+-----------------------
     communications  |   1.2.1 | C:\Octave\Octave\share\octave\packages\communications-1.2.1
            control  |   3.0.0 | C:\Octave\Octave\share\octave\packages\control-3.0.0
     data-smoothing  |   1.3.0 | C:\Octave\Octave\share\octave\packages\data-smoothing-1.3.0
           database  |   2.4.2 | C:\Octave\Octave\share\octave\packages\database-2.4.2
          dataframe  |   1.1.0 | C:\Octave\Octave\share\octave\packages\dataframe-1.1.0
              dicom  |   0.1.1 | C:\Octave\Octave\share\octave\packages\dicom-0.1.1
          financial  |   0.5.0 | C:\Octave\Octave\share\octave\packages\financial-0.5.0
               fits  |   1.0.7 | C:\Octave\Octave\share\octave\packages\fits-1.0.7
fuzzy-logic-toolkit  |   0.4.5 | C:\Octave\Octave\share\octave\packages\fuzzy-logic-toolkit-0.4.5
                 ga  |  0.10.0 | C:\Octave\Octave\share\octave\packages\ga-0.10.0
            general  |   2.0.0 | C:\Octave\Octave\share\octave\packages\general-2.0.0
      generate_html  |  0.1.12 | C:\Octave\Octave\share\octave\packages\generate_html-0.1.12
           geometry  |   2.1.1 | C:\Octave\Octave\share\octave\packages\geometry-2.1.1
              image  |   2.6.1 | C:\Octave\Octave\share\octave\packages\image-2.6.1
 instrument-control  |   0.2.2 | C:\Octave\Octave\share\octave\packages\instrument-control-0.2.2
           interval  |   1.5.0 | C:\Octave\Octave\share\octave\packages\interval-1.5.0
                 io *|   2.4.5 | C:\Octave\Octave\share\octave\packages\io-2.4.5
     linear-algebra  |   2.2.2 | C:\Octave\Octave\share\octave\packages\linear-algebra-2.2.2
               lssa  |   0.1.2 | C:\Octave\Octave\share\octave\packages\lssa-0.1.2
            mapping  |   1.2.1 | C:\Octave\Octave\share\octave\packages\mapping-1.2.1
      miscellaneous  |   1.2.1 | C:\Octave\Octave\share\octave\packages\miscellaneous-1.2.1
                nan  |   3.0.3 | C:\Octave\Octave\share\octave\packages\nan-3.0.3
             netcdf  |  1.0.11 | C:\Octave\Octave\share\octave\packages\netcdf-1.0.11
              nurbs  |  1.3.10 | C:\Octave\Octave\share\octave\packages\nurbs-1.3.10
                ocs  |   0.1.5 | C:\Octave\Octave\share\octave\packages\ocs-0.1.5
             odepkg  |   0.8.5 | C:\Octave\Octave\share\octave\packages\odepkg-0.8.5
              optim  |   1.5.2 | C:\Octave\Octave\share\octave\packages\optim-1.5.2
         quaternion  |   2.4.0 | C:\Octave\Octave\share\octave\packages\quaternion-2.4.0
           queueing  |   1.2.4 | C:\Octave\Octave\share\octave\packages\queueing-1.2.4
             signal  |   1.3.2 | C:\Octave\Octave\share\octave\packages\signal-1.3.2
            sockets  |   1.2.0 | C:\Octave\Octave\share\octave\packages\sockets-1.2.0
          sparsersb  |   1.0.2 | C:\Octave\Octave\share\octave\packages\sparsersb-1.0.2
            specfun  |   1.1.0 | C:\Octave\Octave\share\octave\packages\specfun-1.1.0
            splines  |   1.3.1 | C:\Octave\Octave\share\octave\packages\splines-1.3.1
         statistics  |   1.3.0 | C:\Octave\Octave\share\octave\packages\statistics-1.3.0
                stk  |   2.3.4 | C:\Octave\Octave\share\octave\packages\stk-2.3.4
            strings  |   1.2.0 | C:\Octave\Octave\share\octave\packages\strings-1.2.0
             struct  |  1.0.14 | C:\Octave\Octave\share\octave\packages\struct-1.0.14
             tisean  |   0.2.3 | C:\Octave\Octave\share\octave\packages\tisean-0.2.3
                tsa  |   4.4.1 | C:\Octave\Octave\share\octave\packages\tsa-4.4.1
              video  |   1.2.3 | C:\Octave\Octave\share\octave\packages\video-1.2.3
            windows *|   1.2.4 | C:\Octave\Octave\share\octave\packages\windows-1.2.4
             zenity  |   0.5.7 | C:\Octave\Octave\share\octave\packages\zenity-0.5.7
             zeromq  |   1.2.1 | C:\Octave\Octave\share\octave\packages\zeromq-1.2.1

the error messages:
error: @col2num: no function and no method found
error: called from
    __OCT_xlsx2oct__ at line 245 column 10
    xls2oct at line 201 column 27
    xlsread at line 202 column 29
    Octave_FEM_Global_BeamLoads at line 9 column 6
>> chk_spreadsheet_support ("", 3)

(OCT interface... OK, included in io package)

Checking Excel/ActiveX/COM... not working.
MS-Excel couldn't be started although OF windows is loaded...
1. Checking Octave's Java support... OK.
2. Checking Java dependencies...
  Checking Java JRE presence.... OK, found one.
No Java support found.
No Java support found.
Only ODS 1.2 (.ods) & OOXML (.xlsx) r/w support & .gnumeric read support present
ans = 0

>> javaclasspath
error: javaMethod: could not find library or dependencies: C:\Program Files\Java\jre6\bin\client\jvm.dll
error: called from
    javaclasspath at line 64 column 16

I have the feeling that it might has something to to with the directory path. Installing Octave on C:\Program Files\ had troubles (not able to use the command >>pkg rebuild) too so the admin installed it on C:\ directly.

As I'm not an admin to change much on this computer is there also a workaround to be able to read .xlsx spreadsheets?

Thanks heaps for your help!

Cheers Theresa