POI/HSSF from RPG Articles by Scott Klement

I have written the following articles that describe the creation of Excel spreadsheets from RPG using POI. These articles are all © copyright by Penton Media, and some of them may require a membership with System iNetwork.

Parsing An Excel Spreadsheet with RPG and Java
Parsing An Excel Spreadsheet, Part 2: Handling Dates
New Functions in XLPARSER4
New XLPARSER4 Tool Supports XLSX Format
Excel with RPG and Java
Excel with RPG and Java, Part 2
Excel with RPG and Java, Part 3
HSSF Fills and Colors
HSSF Word Wrapping
How to Update an HSSF Spreadsheet
(ProVIP) Setting Landscape Orientation in HSSF
(ProVIP) Use Timestamps in HSSF Documents
(ProVIP) Set the Paper Size with HSSF
POI Updated to Version 3.0.1
Load Images into Your HSSF Spreadsheets
Locking Cells in HSSF
New POI Release Brings Excel's XLSX Support to RPG
Downloads

You can download my XLPARSER4 and HSSFR4 utilities here. These utilities help you use the POI/HSSF/XSSF Java classes from an RPG program.

POI Version Utility Size Description
3.5 - 3.6 HSSFR4 56 KB RPG Utilities for POI/HSSF
3.0 - 3.2 HSSFR4 43 KB (old) RPG Utilities for POI/HSSF
3.6 XLPARSER4 57 KB RPG Utilities for Parsing Excel
3.0 - 3.2 XLPARSER4 17 KB (old) RPG Utilities for Parsing Excel