HSSF comes from Scott Klement
See:
https://www.scottklement.com
HSSF works with the java classes POI
Scott has two service program version for different POI versions 3.0 - 3.2
and 3.5 - 3.6
We currently use POI3.14. This is the latest version compatible with the
later HSSFR4 service program.
Later versions (4 and on) are using enums and require significant
modifications to the HSS4R4 service program
The POI Classes can be downloaded from:
https://archive.apache.org/dist/poi/release/bin/
You will need to check what is in your classpath to determine what version
you currently have/using.
Having multiple versions on the same system is fine, just need to set the
library list and classpath correctly.
Note: PUT YOUR JAVA CLASSES IN YOUR OWN DIRECTORY, NOT
qibm\UserData\Java400\ext
As far as creating multiple spreadsheets at the same time, we have not
done that but we do create multiple workbooks in one spreadsheet at the
same time.
Hope this helps a little.
Cheers
Don
From: "DEnglander--- via RPG400-L" <rpg400-l@xxxxxxxxxxxxxxxxxx>
To: rpg400-l@xxxxxxxxxxxxxxxxxx
Cc: DEnglander@xxxxxxxxxxxxxxx
Date: 07/01/2022 01:17 AM
Subject: RPG creating Excel spreadsheets
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>
I have inherited quite a few RPG programs that create actual spreadsheets.
They are all tied to two Binding Directories, either HSSF or HSSF2.
I know how to make RPG interact with these to create a spreadsheet on the
IFS.
My questions are:
1. How can I tell what version(s) of HSSF I am currently running?
2. How can I find the current version of HSSF that is available?
3. If we are not on the most current, is it possible to have the existing
two plus a third [most current] installed on one machine?
4. Is it possible for one RPG program to create two spreadsheets
simultaneously?
We are running V7R3 and fairly current with PTFs.
Thank you,
Doug
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient.
If you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify
the sender by reply e-mail, and then destroy all copies of the
transmission."
midrange.com
