I have a bunch of data (parsed european bank transactions) that need additional massaging.

I have been writing out .csv files and then importing into OO Calc and then doing light formatting etc. on these files.

It would save time if I could write out the files directly (with formats, formulas, etc) so I could see how successful
my massaging has been (does it balance, how many categories are left, etc.)

All is in Ruby.

I have just stumbled onto roo and thought it would do the job until I read that it is read-only. A pity.

Date: 2008-09-13 21:38
Sender: Bob Gustafson

Hmm. I looked at a spreadsheet archive with ruby zipfile.
There are quite a few files..

I could just snarf up the extra files and write them into an
output zip file, along with a new 'content.xml' file.

The format of the 'content.xml' file is tedious. It could be
done, but I do have a deadline, and perhaps there is an
easier way to do my project..