We all know Groovy as our super hero for enhancing Java with all the latest programming features. When not in super hero mode, Groovy is just as happy as a mild-mannered office worker. Here are some links to get you started if you need some help around the office:
- The Scriptom Module can be used to script Word, Excel, PowerPoint etc. on Windows.
- OpenXML4J is a Java library dedicated to the creation and manipulation of Office Open XML (ECMA-376) and OPC based documents (for example Office 2007 Word, Excel and PowerPoint documents). OpenXML4J provides you a way to create and manipulate Open XML documents for a bunch of scenarios without using any office suite.
- Apache POI consists of APIs for manipulating various file formats based upon Microsoft's OLE 2 Compound Document format using pure Java. In short, you can read and write MS Excel, Word, PowerPoint files (97-2003 with varying levels of support) using Java.
- WebTest's Excel Steps lets you test Excel content. The examples are in XML (Ant build format) but you can use Groovy with AntBuilder too.
- Using Java to Crack Office 2007 is an article about using Java to read and write any Office 2007 document. You can use Groovy's XML features to make these examples even simpler.
- Ted Neward's Best of Both Worlds whitepaper describes how to make the Java and Microsoft/.Net worlds interoperate. Most of those examples apply equally well to Groovy and .Net.
- JExcel is a commercial offering that provides an effective way to integrate Microsoft Excel into Swing applications.