![]() This method can only read the workbook it can't change it. The HSSF classes provide two different ways to read an RPG spreadsheet.Įvent model - Java reads the entire Excel workbook in order, one cell at a time, and calls your RPG subprocedures for each cell that has data. I have written the following articles that describe how to use HSSFR4 from your RPG programs. The source code from this article also contains bug fixes. ![]() The articles below contain older versions of the code that might not be compatible with version 3.0.1. ![]() Note: When reading the following articles, please use the source code from this article (see the above link). You can download the updated HSSFR4 code (tested with POI version 3.0.1) from the following link: I named my service program HSSFR4 (the R4 stands for "RPG IV"). To make it as easy as possible to write HSSF code from RPG, I've created a service program full of routines. On occasion, I've used it for longer reports, but only when I can run the report as a long-running batch job where it doesn't matter if it takes a long time to complete. They can print it if they like, or they can use Excel's many tools to sort it, change formulas, create charts, and so forth.īecause HSSF is relatively slow, I use it primarily for shorter (less than 20 pages) reports. That user can then open the document in Excel. Instead of writing an RPG program that prints a report to a System i output queue, I write them to an Excel file stored in the IFS and e-mail them to the person who requested the report. ![]() I find them to be an attractive way of writing report programs. ![]() XLS files that you can download and view on a PC that's running Excel. The HSSF classes work nicely for creating. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |