Re: Current info on writing XLSX with RPGLE

Should be HSSF in the binding directory if you use Scott's stuff. We run
both
XLS and XLSX and there was a time when we were using/testing both.
Also the module is HSSFR4 not HSSF4.

The jar files come from APACHE POI by the way. I've been using POI 3.11
without
much of a problem. But 3.6 is tried and true for us. Your experience may
be different.

Bill





From: broehmer@xxxxxxxxxxxxxxx
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 05/28/2015 05:22 PM
Subject: Re: Current info on writing XLSX with RPGLE
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



Assuming that you are going to use Scott's methods, how are you
going to get the required jar files into your IFS if you can't use the
network?

Inside of Scott's HSSR4 module he outlines all the required files and copy


statements for XLSX. If you can get that you can follow the steps.
It's pretty simple.
Then:

A CLP to override the environment would be useful:
PGM
ADDENVVAR ENVVAR(CLASSPATH) +
VALUE('/QIBM/USERDATA/POI-3.6/POI-3.6-20091214.JAR+
:/QIBM/USERDATA/POI-3.6/POI-OOXML-3.6-20091214.JAR+
:/QIBM/USERDATA/POI-3.6/POI-OOXML-SCHEMAS-3.6-20091214.JAR+
:/QIBM/USERDATA/POI-3.6/DOM4J-1.6.1.JAR+
:/QIBM/USERDATA/POI-3.6/JSR173_1.0_API.JAR+
:/QIBM/USERDATA/POI-3.6/XBEAN.JAR+
:/QIBM/USERDATA/JAVA400/cdh+
:/QIBM/USERDATA/JAVA400/mail.jar+
') +
LEVEL(*JOB) +
REPLACE(*YES)
ENDPGM
Then an rpg program like this will prove it:


H DFTACTGRP(*NO) BNDDIR('HSSF2')

/include mylib/QPROTOTYPE,hssf_H
/copy mylib/QPROTOTYPE,STDIO_H
/copy mylib/QPROTOTYPE,IFSIO_H
D book s like(SSWorkbook)
D sheet s like(SSSheet)
D row s like(SSRow)
D cell s like(SSCell)
D filename s 100a varying
/free
ss_begin_object_group(100);

book = new_XSSFWorkbook();
filename = '/home/example.xlsx';

sheet = SS_newSheet(book: 'Test');
row = SSSheet_createRow(sheet: 0);
cell = SSRow_createCell(row: 0);
SSCell_setCellValueD(cell: 1234);
HSSF_Save(book:filename);
HSSF_End_Object_Group();
*inlr = '1';

Hope that can get you started,

Bill




From: Jim Franz <franz9000@xxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 05/28/2015 03:42 PM
Subject: Current info on writing XLSX with RPGLE
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



There is a long list of previous posts over several versions of POI. What
I
am having trouble with is the latest version of instructions, downloads to
get, sample code for V7R1 or later.
Has anyone been through this lately and can point me to recent post or
article?
Also, if on personal websites, I have to work around our network blocking
all personal sites (like Scott's..- just have to do from home network).
Goal is quick and easy Excel reports with basic formatting, headers, and
totals. No budget for vendor tools. I've done this many years ago, when
1st
posted, on other systems.
Jim Franz