Category Archives: opendocument

Converting ODS to CSV

>Recently I’ve released an ODS (OpenDocument Spreadsheet) to CSV (Comma-Separated Values) converter. It’s available from GitHub:

The current version (0.1) is not perfect, I’ve documented some issues, mainly related to empty fields/records being output. After releasing version 0.1 I created some unit tests; once they pass, these issues should be resolved.

During development, it turned out it’s really easy to parse an ODS file, since it’s just a ZIP file with the contents contained in simple XML file inside it.

The converter uses SAX to parse the XML inside it, to minimize memory usage. It comes with a Java library, a command line program and an Apache Ant task. And there are no external dependencies other than a Java runtime environment (version 1.5 or up).


>More improvement suggestions for Keynote

>Last week I already posted some suggested improvements for Keynote. Here’s some more:

  • OpenDocument support, so files from Impress can be imported and exported.
  • On iDVD support: Export interactive sheets to DVD menus. Currently you can only export video, the interactivity is lost.

Still, I haven’t seen any program that allows me to create stunning presentations with just a small set of powerful tools. Keynote beats Powerpoint and OpenOffice Impress hands tied to the back…