If you’re writing code using Windows COM or in .NET it’s pretty easy to script Microsoft Office applications like Excel, Word, and PowerPoint to create MS Office documents. However, if you’re running a Java application on Linux and you need to manipulate an MS Access database or create an MS Word document what do you do? Easy, you use one of the following utilities:
- Jakarta POIFS – Open Source Java API To read/write Microsoft Compound Document (OLE2) files.
- Jakarta POI HSSF – Open Source Java API To access/create Microsoft Excel files.
- Jakarta POI HWPF – Open Source Java API To access/create Microsoft Word files.
- Jackcess – Open Source Java API for reading and writing MS Access databases.