Re: xlsread in Octave 3.6.4

[Markus]

Am 2013-10-21 00:16, schrieb Philip Nienhuis:
> octave:19> [raw, xls] = xls2oct (xls, 2); size (raw)
> ans =
>      31   1024
> octave:20> [raw, xlsu] = xls2oct (xlsu, 2); size (raw)
> ans =
>      36   1024
> (xlsxread misses 5 rows)

Hi Philip

It's fixed now.

octave-cli:8> size(xlsxread ('testOOXML.xlsx',2 ))
ans =

                    36                  1024

by the way, matlab run out of memory (8GB RAM) while try to read >> 
xlsread ('testOOXML.xlsx',2 );
just the magic SysRq key saved my uptime :D


> octave:22> [raw, xls] = xls2oct (xls, 4); size (raw)
> ans =
>    12    5
> octave:23> [raw, xlsu] = xls2oct (xlsu, 4); size (raw)
> ans =
>    13    5
> (Ambiguous. The lower row that xlsxread misses contains results from a
> deliberately erroneous spreadsheet formula (#N/A). Let's just declare
> this behavior correct)

yes, it's correct.

octave-cli:9> size(xlsxread ('testOOXML.xlsx',4 ))
ans =

                    12                     5

And Matlab do the same

> > size(xlsread ('testOOXML.xlsx',4 ))

ans =

    12     5


I've just pushed it to my one file version to github. I will merge it 
into the svn files on weekend.

furthermore after my last changes i got some warnings sometimes


octave-cli:3>  size(xlsxread ('excel2007.xlsx' ))
ans =

                     4                     2

octave-cli:4>  size(xlsxread ('excel2010.xlsx' ))
ans =

                     4                     2

octave-cli:5> size(xlsxread ('Test1.xlsx' ))
warning: implicit conversion from matrix to sq_string
warning: implicit conversion from matrix to sq_string
ans =

                     4                     8

octave-cli:6> size(xlsxread ('Testtime.xlsx' ))
warning: implicit conversion from matrix to sq_string
warning: implicit conversion from matrix to sq_string
ans =

                     5                     9

octave-cli:7> size(xlsxread ('Mergedranges.xlsx' ))
warning: implicit conversion from matrix to sq_string
warning: implicit conversion from matrix to sq_string
ans =

                    15                  1015

octave-cli:8> size(xlsxread ('testOOXML.xlsx',2 ))
ans =

                    36                  1024

octave-cli:9> size(xlsxread ('testOOXML.xlsx',4 ))
ans =

                    12                     5



but yeah, I'll take a look into it on weekend, improve it, clean up the 
code and add more comments.

cheers,
markus

--
https://github.com/markuman
Jabber: address@hidden