You have to think of this as more of a tool, rather than referring to it as software, because, you'll have to write code to utilize it, and its not something you install and have a manual for, and a menu you start up to check things like version levels and other stuff. Scott Klement at one time created a number of interfaces for using this tool from RPG. It has not been updated for quite some time, but, we've updated it for our own uses in house.
#1 - What version do you have installed? You download the java .jars and put them in a directory, and then you point your program to using that directory when you want to use the tool. You don't really have it installed in the traditional sense. The .jar files are usually named with the version of the tools that you downloaded, so, that should give you the version.
#2 - Go to
https://poi.apache.org/download.html to get the latest stable build level. Be warned though, that the current version is more difficult to use than some of the older versions when accessing from RPG.
#3 - Yes. I've created filled cells with white font often. I don't recall rotating it.
#4 - The actual tool was not specifically designed for running on the I, its just java. So, you can go here
https://poi.apache.org/index.html, and see some javadocs, and there are some examples.
#5 - Apache POI is the overall project name for working with office documents. HSSF is specific to spreadsheets within that POI project. Interesting trivia is that it actually stands for "Horrible SpreadSheet Format". There is also XSSF which is very closely related, and included with some of the same .jars, for generating the newer .xlsx type spreadsheets.
-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of DEnglander@xxxxxxxxxxxxxxx
Sent: Friday, October 25, 2019 9:35 AM
To: midrange-l@xxxxxxxxxxxxxxxxxx
Subject: POI/HSSF
CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe.
I would like some basic help with the POI software on our IBMi. I have the following questions:
1. How do I determine the version that is installed?
2. What is the current version?
3. Is it possible to create a cell style with multiple characteristics [i.e. Red fill, white font, rotate 90 degrees]?
4. Is there any comprehensive manual or URL for this software?
5. Is there a difference between the terms POI and HSSF?
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."
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/midrange-l.
Please contact support@xxxxxxxxxxxx for any subscription related questions.
Help support midrange.com by shopping at amazon.com with our affiliate link:
https://amazon.midrange.com
midrange.com
