Does anyone use cloneSheet or copyRows methods? I'm trying to use one or the other in my RPGFree project and I can't seem to get either one to work. Does anyone have an example of the extproc for one or both of these methods? The following are my attempts that do not work:
D cloneSheet...
D pr O class(*JAVA:
D 'org.apache.poi.hssf.usermodel-
D .HSSFWorkbook')
D extproc(*JAVA:
D 'org.apache.poi.hssf.usermodel-
D .HSSFWorkbook':
D 'cloneSheet')
D sheetNo like(jint) value
D copyRows...
D pr O class(*JAVA:
D 'org.apache.poi.xssf.usermodel-
D .XSSFSheet')
D extproc(*JAVA:
D 'org.apache.poi.xssf.usermodel-
D .XSSFSheet':
D 'copyRows')
D srcStrRow like(jint) value
D srcEndRow like(jint) value
D dstStrRow like(jint) value
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Don Brown via RPG400-L
Sent: Wednesday, June 17, 2020 4:46 PM
To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
Cc: Don Brown <DBrown@xxxxxxxxxx>
Subject: RE: HSSF POI Copy or Clone
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
