Re: Test files [WAS: Re: xlsread in Octave 3.6.4]

[Markus Bergholz]

On Sun, Sep 15, 2013 at 9:56 PM, Philip Nienhuis <address@hidden> wrote:

(sent privately. Please do NOT respond privately)

Philip Nienhuis wrote:
:
<snip>
:

This weekend I'll sent you a few test Excel files with empty
row/columns, merged cells, dates, times, booleans, formulas, erroneous
formulas and -consequently- error values in the cached value attributes,
etc.

Attached. I've combined a few test spreadsheets I had lying around.

I used most of these for exploring ranges of occupied cells (which in OOXML turns out to be extremely easy, the range is in one of the first nodes of the worksheets) and cell value types. You'll find a few spreadsheet formulas which -intentionally- contain errors.

Good luck with it,

here are the mat files from octave
http://p.osuv.de/index.php/1XY/
http://p.osuv.de/index.php/ZtW/

it reads faster than matlab :)

* Mergedranges.xlsx

looks nearly the same as with matlab R2010 at work. One difference is Matlab start read in column J. My xlsxread start at A as defined in the sheet. So i guess matlab ignore the real defined size.

the values are the same. (as far as i quickly see).

* testOOXML.xlsx

same for this file.

the values are the same.

the question is now if (get rid of|change) line 102-109+122 to get the same wrong result as matlab or ignore this and we are done?
 

Philip

--
icq: 167498924
XMPP|Jabber: address@hidden