RE: HSSF POI Copy or Clone

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