Spreadsheet Parser in Java/Groovy

Question

Hi I'm looking to parse spreadsheets (xls/ods) in Groovy. I have been using the Roo library for Ruby and was looking to try the same tasks in Groovy, as Java is already installed on a development server I use, and I would like to keep the number of technologies on the server to a simple core few.

I am aware that the ods format is zipped XML, and so can be parsed as such, but I would like to process the file using spreadsheet concepts, not XML concepts.

The ability to process xls files is not of major importance, but would save me having to save multiple xls files to ods (as this is for parsing data from clients).

Thanks

Answer 1

I would suggest Apache POI for access to .xls files.

I've never had to work with the .ods format, so no information on that one.

Answer 2

There's also JExcelAPI, which has a nice, clean, simple interface (for the most part).

Can't help you with ODS Files though.