We run POI Version 3.14
Versions later than that have changed to using enums and will require
changes to handle that.
So I would suggest using 3.14 and see how you go.
(Unless Mark has had a chance to complete his work and wants to share :-)
)
Cheers
Don Brown
From: "Jordan Waterhouse" <JordanWaterhouse@xxxxxxxxxxxx>
To: "RPG programming on IBM i" <rpg400-l@xxxxxxxxxxxxxxxxxx>
Date: 18/06/2020 03:10 AM
Subject: RE: HSSF POI Copy or Clone
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>
I'm using .xlsx (XSSF) also. I tried to add copyRows and cloneSheet to
SK's POI implementation but neither is working. Can you give me a hint on
how to add the new functions? I must be doing something wrong in my
EXTPROCs.
Did you have to make any changes to SK's POI implementation to go to POI
4.1.2? Whenever I try using a new version of POI (3.17), I get a
procedure pointer error on ss_getSheet. Everything works fine on POI 3.6.
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of
Eddie Gomez
Sent: Monday, June 15, 2020 7:36 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: HSSF POI Copy or Clone
We are using SK’s POI implementation in a POI 4.1.2 environment.
We used the .xls (HSSF) implementation at first many years ago when that
format was still the predominant format, and now exclusively use .xlsx
(XSSF) now that Office365 is the norm. Anyone using .xls is told to
upgrade. HSSF resulted (for us) larger file sizes, with XSSF being
roughly 40-50% of the size.
Vern is correct. SK’s package comprises of just a small fragment of the
entire POI command-set. Only the most basic, common functions were
included. It’s up to the developer to add other functions as needed. It
took me a while to understand what’s going on under the hood, but once it
“clicked”, adding new Java functions using the POI manual is actually
quite simple providing it’s merely a straight call to the proper Java API.
We don’t make the new code backwards-compatible with HSSF. It’s all XSSF
going forward.
On Jun 15, 2020, at 16:32, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:
I checked the easy400.net site - there are some utilities for Excel
there, but they are even more selective, I think, than the functions Scott
selected.
Still, there is a kind of XML-language script for creating spreadsheets,
both XLS and XLSX, that is available at easy400.
Regards
Vern
On 6/15/2020 6:21 PM, Vernon Hamberg wrote:
Scott's library is not limited to HSSF, it also does XSSF.
Now he has NOT implemented every function that you have in POI - people
are welcome to add things to the SRVPGM - it's open source, after all.
There might be something at the easy400.net site, I think Giovanni
Perotti or someone else used Scott's API to make something with more
functions.
Regards
Vern
On 6/15/2020 3:38 PM, Jordan Waterhouse wrote:
I've been using Scott Klement's HSSF library to create and modify
spreadsheets and it works great! Is there any type of copy or clone that
would work to copy entire rows or sheets? I've tried to implement
CopyRows and CloneSheet but cannot get either one to work. Has anyone
been able to get these to work with POI and RPGFree?
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
--
This is the RPG programming on IBM i (RPG400-L) mailing list To post a
message email: RPG400-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit:
https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://archive.midrange.com/rpg400-l.
Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.
Help support midrange.com by shopping at amazon.com with our affiliate
link:
https://amazon.midrange.com
midrange.com
