[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: xlsread in Octave 3.6.4
From: |
Markus |
Subject: |
Re: xlsread in Octave 3.6.4 |
Date: |
Wed, 30 Oct 2013 22:23:42 +0100 |
User-agent: |
Roundcube Webmail/0.9.5 |
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
- Re: xlsread in Octave 3.6.4, Markus, 2013/10/04
- Re: xlsread in Octave 3.6.4, Philip Nienhuis, 2013/10/04
- Re: xlsread in Octave 3.6.4, Markus, 2013/10/15
- Re: xlsread in Octave 3.6.4, Philip Nienhuis, 2013/10/15
- Re: xlsread in Octave 3.6.4, Philip Nienhuis, 2013/10/20
- Re: xlsread in Octave 3.6.4, Markus, 2013/10/21
- Re: xlsread in Octave 3.6.4, Philip Nienhuis, 2013/10/21
- Re: xlsread in Octave 3.6.4, Markus, 2013/10/21
- Re: xlsread in Octave 3.6.4, Markus, 2013/10/31
- Re: xlsread in Octave 3.6.4,
Markus <=