Re: Problem with sheet identifier in xls2oct

[Joao Rodrigues]

On 27-08-16 22:49, Philip Nienhuis wrote:
> Joao Rodrigues wrote
> > Essentially I cannot declare which sheet xls2oct is supposed to open. A
> > minimal example is as follows:
> >
> > I created an xlsx file with a 'Sheet1' worksheet and some content in
> > A1:A3.
> >
> > Then I run inside octave:
> >
> > pkg load io
> > xls = xlsopen('test.xlsx');
> > sheetstr = 'Sheet1';
> > tmp = xls2oct (xls, 'Sheet1', 'A1:A3');
> >
> > and I get the following error:
> >
> > error: @col2num: no function and no method found
> > error: called from
> >       __OCT_xlsx2oct__ at line 301 column 12
> >       xls2oct at line 210 column 27
> > error: evaluating argument list element number 1
> >
> > with the last four lines repeated several times.
> >
> > Octave version is 4.0.0
> > OS is Ubuntu 15.10
> just a couple of questions:
>
> - Which io package version ?  (type:
> pkg list
> in the Octave terminal)
>
> - what output do you get from
> xlsfinfo ("test.xlsx")
> ?
> (I'd guess more or less the same error message)
>
> Looking at the actual error message "error: @col2num: no function and no
> method found" I suspect a faulty io package installation. Reinstalling it
> might help.
>
> But let's await your answers.
>
> Thanks,
>
> Philip
reinstalling the package solved the problem

(in hindsight an obvious thing to do, really)

the previous package version was 2.2.4, now is 2.4.2.

many thanks!
joao