Re: ODF spreadsheets

[Mats Hedlund]

Muthiah Annamalai wrote:
> <div class="moz-text-flowed" style="font-family: -moz-fixed">Tribo
> Laboy wrote:
>> Hello.
>>
>> Is this anywhere close to what you are looking for?
>>
>> http://www.mathworks.com/matlabcentral/fileexchange/loadFile.do?objectId=18222&objectType=file
>>
>>
>> I confirmed it works under MATLAB, but under Octave on WinXP I Have
>> some problems with uncompressing the the ods file. I will look a bit
>> deeper into it when I have some more time.
>>
>> Regards,
>> TL
>>   
> It looks interesting, GPL'ed m-file code. Relies on xmlread() which is
> in octave-forge
> toolbox I think.
>
> Also the problem with ODF I suspect its huge to cover all bases, and
> any implementation
> is going to be a broken subset. Writing a huge matrix in ascii and
> putting that into a large
> XML file and zipping it up is not my idea of a nice matrix format.
>
> Best method was suggested earlier; csv read/write. Octave loads CSV's
> nicely.
Sure, numbers can be dealt with but there are two missing
functionalities with CSV:
1. can not deal with strings (for variable names, headers etc)
2. can not read/write data to/from a specific sheet in a ODS file

In my mind that's all what would be needed for dealing with ODS formats
from a pragmatic standpoint. Looks like the m-file referred to is
dealing with the read part. Could be a good starting point for adding
writing capabilities. I'll give it a spin.
/Mats


>
> -Muthu
>
>
>
> </div>