How to read an Open Office spreadsheet?

Question

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

Answer 1

I never used it, but Open Office has a Java API , which, of course, can also be used from Groovy. It seems like the best way to start reading is: Developer's Guide , Java UNO Reference and samples in Java and (hey!) Groovy . Hope this helps!

Answer 2

- , Spring , Groovy JMX. Groovy Open Office.

Answer 3

/ SQL, . goovy - http://www.ifcx.org/

Answer 4

OpenOffice ZIP , XML, ( ). .

calc - . , . , ZIP-, content.xml XML-.

, . API- UNO. Java. , , , ODF . , , .

. -, , .

Answer 5

Groovy ( ), .

How to normally read an Open Office spreadsheet document? There are tools for creating one (ooo-python), but not for reading. They are XML, but just stupidly immersed in it, and trying to get the correct logic for retrieving the data I want seems so sub-optimal.

I would like to use features similar to Excel COM support, but from a command line tool (or scripting language).