Since 2004, I've been writing articles about using the HSSF component of Apache's POI to create Excel spreadsheets from RPG. The articles have been wildly popular, but they were missing something: support for Microsoft's new file formats. You see, starting with Microsoft Office 2007, the default file format for Excel has been the Open Office XML (OOXML) format for spreadsheets, represented by the extension .XLSX. Although this has been the standard for Excel users for a few ...

REGISTER NOW TO ACCESS THIS ARTICLE

All registered users get access to premium content on iPro Developer for free.

Already registered? here.