Re: xlsread in Octave 3.6.4

[Philip Nienhuis]

Philip Nienhuis wrote:
<snip>
> As to what I think is needed for xlsx in the io package (1.2.4):
> -----------------------------
> xlsread.m:
> Nothing (apart from the help text header, I'll do that)

Done.

> xlsopen.m, xls2oct.m, xlsclose.m:
> Extra stanzas for OCT interface, plus header text. A'la similar parts
> for odsopen/ods2oct/odsclose
> I could do these too, it's not much work.

Done.
Also did private/getxlsinterfaces.m

> private/ functions:
> -------------------
> __OCT_spsh_open__.m
> Unzipping the xlsx file, storing the unzipped dir pointer in the file
> pointer struct, perhaps also the sheet file names. Most is already in
> place (at the top), there's a section at the bottom for xlsx.
>
> __OCT_xlsx2oct__.m
> New file. Contains most of your xlsxread.
>
> __OCT_getusedrange__.m
> Needs a little stanza where the stored used range is to be assessed.
> Easy, use the <dimension ref="<range>" /> from the top of the worksheet
> files; you could use getxmlnode.m/getxmlattv.m to get the value,
> parse_sp_range to translate it to row/column numbers.
>
> __OCT_spsh_close__.m
> A stanza for xlsx. Just wiping the tmpdir and returning an empty struct
> is all that is needed.
>
> __OCT_spsh_info__.m
> To be assessed later. AFAICS it could be used w/o change if you set up
> the file pointer struct (output of __OCT_spsh_open__.m) similar to what
> is done for .ods

Could you adapt/create these files, please?

Oh before I forget:
Please do watch line endings (make sure they're LF only, not CR-LF).
You can use dos2unix for that.

Thanks,

Philip