Re: error: 'xlsread' undefined

[Michele]

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?