How to read an Open Office spreadsheet?

Question

How can I read an Open Office 3.0 spreadsheet (.ods) from Groovy? I'd like to select specific columns from a named worksheet. Ideally, it would be useful to add a 'where' clause, or other criteria clause.

Answer 1

Might be something here at Spring Factories or here at Groovy and JMX. There is a forum for Groovy and Open Office.

Answer 2

I've never used it, but Open Office has a Java API, which of course you could use from Groovy as well. It looks like the best places to start reading are the Developer's Guide, the Java UNO Reference, and the samples in Java and (hey!) Groovy. Hope that helps!

Answer 3

Since the title does not mention Groovy (only question specifics does), I didn't want to make this a new question.

How to generally read an Open Office spreadsheet document? There are tools for creating one (ooo-python) but not for reading one. They are XML but just bluntly diving into that and trying to get the right logic of extracting the data I want seems so sub-optimal.

What I'd like is features similar to Excel COM support, but from a command line tool (or scripting language).

Answer 4

Could you export the table / spreadsheet as SQL entries then use that. You could also look at this plugin for goovy -- http://www.ifcx.org/