Re: error: 'xlsread' undefined

[Lester Anderson]

Works fine for me when I ran the test. One query, does it need Java as
a dependency?

Got this first time I open Octave:

>> [num,text] = xlsread('test.xlsx')
Detected XLS interfaces: warning:  No Java support found (no Java JRE?
no Java pkg installed AND loaded?)
warning: called from
    getxlsinterfaces at line 125 column 11
    xlsopen at line 246 column 17
    xlsread at line 197 column 11

num =

   1
   2
   3

text =
{
  [1,1] = nums
  [2,1] =
  [3,1] =
  [4,1] =
  [1,2] = text
  [2,2] = a
  [3,2] = b
  [4,2] = c
}

Repeat the command and the Java warning doesn't pop up, very odd.

e.g.
>> [num,text] = xlsread('test.xlsx')
num =

   1
   2
   3 etc.

Tested on Octave 4.0.1

On 22 April 2016 at 08:25, Michele <address@hidden> wrote:
>
>
> On 22/04/16 07:26, Reza wrote:
>>
>> Hi guys,
>>
>> I have a problem in reading *.xlsx files.
>> I have *installed *io package and *loaded *this package.
>>
>> The command that I want to run is:
>> *[nums, text] = xlsread('Input.xlsx')*
>>
>> But I receive this error:
>>
>> *warning: Functions for spreadsheet style I/O (.xls .xlsx .sxc .ods .dbf
>> .wk1
>> etc.)  are provided in the io package.  See <http://octave.sf.net/io/>.
>>
>> Please read <http://www.octave.org/missing.html> to learn how you can
>> contribute missing functionality.
>>
>> error: 'xlsread' undefined near line 1 column 14*
>>
>> When I use the command "pkg list", it shows:
>>
>> Package Name   | Version | Installation directory
>> ---------------+---------+-----------------------
>>        control  |   2.6.2 | /usr/share/octave/packages/control-2.6.2
>>        general  |   1.3.4 | /usr/share/octave/packages/general-1.3.4
>>          image  |   2.2.0 | /usr/share/octave/packages/image-2.2.0
>>            * io  |   2.4.1 | /home/octave/io-2.4.1*
>> miscellaneous  |   1.2.0 | /usr/share/octave/packages/miscellaneous-1.2.0
>>          optim  |   1.3.0 | /usr/share/octave/packages/optim-1.3.0
>>       parallel  |   2.2.0 | /usr/share/octave/packages/parallel-2.2.0
>>         signal  |   1.2.2 | /usr/share/octave/packages/signal-1.2.2
>>        specfun  |   1.1.0 | /usr/share/octave/packages/specfun-1.1.0
>>     statistics  |   1.2.3 | /usr/share/octave/packages/statistics-1.2.3
>>         struct  |  1.0.10 | /usr/share/octave/packages/struct-1.0.10
>>
>> Please let me know how I can solve this problem.
>>
>> Best,
>> Reza
>>
>>
>>
>> --
>> View this message in context:
>> http://octave.1599824.n4.nabble.com/error-xlsread-undefined-tp4676441.html
>> Sent from the Octave - General mailing list archive at Nabble.com.
>>
>> _______________________________________________
>> Help-octave mailing list
>> address@hidden
>> https://lists.gnu.org/mailman/listinfo/help-octave
>
>
> Dear Reza,
>
> I don't know if this can help you, but  I tested the function with a simple
> .xlsx file: in the top-right corner it had
>      nums | text
>         1     | a
>         2     | b
>         3     | c
> then
>
>>[num,text] = xlsread('Input.xlsx')
> Detected XLS interfaces: num =
>
>    1
>    2
>    3
>
> text =
> {
>   [1,1] = nums
>   [2,1] =
>   [3,1] =
>   [4,1] =
>   [1,2] = text
>   [2,2] = a
>   [3,2] = b
>   [4,2] = c
> }
>
> (which I think is the kind of result you are trying to obtain).
> Are you sure you loaded the package in your current session?
>
>
> _______________________________________________
> Help-octave mailing list
> address@hidden
> https://lists.gnu.org/mailman/listinfo/help-octave