Thu Feb 16 19:17:53 EST 2012

Writing opendocument spreadsheets

While it's not too hard to write CSV (it's not too easy either) that
still leaves some manual steps at import, like selecting separators,
column types, date formats etc..

Isn't there a simple way to have typed columns, and put them in a
spreadsheet?  I guess that's called SQL, but it's not 100% standard

Anyways.  I'm happy I got my data into racket by mining a GnuCash XML
file.  Now the next step is to put it into a spreadsheet.

So I'm wondering about open document format[1] ods spreadsheets.

There's content.xml in the zip which seems straightforward, but I
don't really want to wade through all the rest.  Is there a simpler
format that has typed columns?  I don't need so many bells and

[1] http://en.wikipedia.org/wiki/OpenDocument
[2] http://www.openoffice.org/xml/general.html
[3] http://stackoverflow.com/search?q=ods+xml&submit=search