Groovy - writing and formatting excel 2010

What are th options for working with an excel workbook from within a groovy (java) environment? We would like to be able to use the following features

1. add sheets
2. add cells: headings and data
3. format columns, rows, cells

and potentially

1. form pivot tables
2. copy the pivot table by value
3. paste clipboard by value on another screen

Essentially this will allow us to forma pivot table but remove the underlying data from the worksheet.

Thoughts? Thanks in advance.

Try apache poi. Can definitely perform your first list of requirements. I have used this api a good bit. If you have any questions, please feel free to ask.

Several Java libraries are available to handle the requirements you're looking for:

• Apache POI
• OpenOffice API
• JExcelAPI
• Jacob
• ...

Not sure which one can easily handle pivot tables.

Good luck with your project! Wim

This page describes some more Groovy-specific options, but my recommendation would be to use Apache POI, either from Java or Groovy