× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. RPG400-L
  3. June 2020

Re: HSSF POI Copy or Clone

Just looking at the poi definitions, cloneSheet returns a a sheet not a workbook. copyRows the only two definitions I can find don't match yours. One has 4 parameters, the other has 3, but different types than you are showing. I haven't tried to create a prototype for a java class in a very long time, so I may be barking up the wrong tree.

On Mon, 2020-06-22 at 17:36 +0000, Jordan Waterhouse wrote:

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:

<mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>

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 <

<mailto:rpg400-l@xxxxxxxxxxxxxxxxxx>

rpg400-l@xxxxxxxxxxxxxxxxxx



Cc: Don Brown <

<mailto:DBrown@xxxxxxxxxx>

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" <

<mailto:JordanWaterhouse@xxxxxxxxxxxx>

JordanWaterhouse@xxxxxxxxxxxx



To: "RPG programming on IBM i" <

<mailto:rpg400-l@xxxxxxxxxxxxxxxxxx>

rpg400-l@xxxxxxxxxxxxxxxxxx



Date: 18/06/2020 03:10 AM

Subject: RE: HSSF POI Copy or Clone

Sent by: "RPG400-L" <

<mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>

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:

<mailto:rpg400-l-bounces@xxxxxxxxxxxxxxxxxx>

rpg400-l-bounces@xxxxxxxxxxxxxxxxxx

] On Behalf Of Eddie Gomez

Sent: Monday, June 15, 2020 7:36 PM

To: RPG programming on IBM i <

<mailto:rpg400-l@xxxxxxxxxxxxxxxxxx>

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 <

<mailto:vhamberg@xxxxxxxxxxxxxxx>

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:

<mailto:RPG400-L@xxxxxxxxxxxxxxxxxx>

RPG400-L@xxxxxxxxxxxxxxxxxx

To subscribe, unsubscribe,

or change list options,

visit:

<https://lists.midrange.com/mailman/listinfo/rpg400-l>

https://lists.midrange.com/mailman/listinfo/rpg400-l


or email:

<mailto:RPG400-L-request@xxxxxxxxxxxxxxxxxx>

RPG400-L-request@xxxxxxxxxxxxxxxxxx


Before posting, please take a moment to review the archives at

<https://archive.midrange.com/rpg400-l>

https://archive.midrange.com/rpg400-l

.


Please contact

<mailto:support@xxxxxxxxxxxxxxxxxxxx>

support@xxxxxxxxxxxxxxxxxxxx

for any subscription related

questions.


Help support midrange.com by shopping at amazon.com with our affiliate

link:

<https://amazon.midrange.com>

https://amazon.midrange.com



--

This is the RPG programming on IBM i (RPG400-L) mailing list To post a

message email:

<mailto:RPG400-L@xxxxxxxxxxxxxxxxxx>

RPG400-L@xxxxxxxxxxxxxxxxxx

To subscribe, unsubscribe, or

change list options,

visit:

<https://lists.midrange.com/mailman/listinfo/rpg400-l>

https://lists.midrange.com/mailman/listinfo/rpg400-l


or email:

<mailto:RPG400-L-request@xxxxxxxxxxxxxxxxxx>

RPG400-L-request@xxxxxxxxxxxxxxxxxx


Before posting, please take a moment to review the archives at

<https://archive.midrange.com/rpg400-l>

https://archive.midrange.com/rpg400-l

.


Please contact

<mailto:support@xxxxxxxxxxxxxxxxxxxx>

support@xxxxxxxxxxxxxxxxxxxx

for any subscription related

questions.


Help support midrange.com by shopping at amazon.com with our affiliate

link:

<https://amazon.midrange.com>

https://amazon.midrange.com


--

This is the RPG programming on IBM i (RPG400-L) mailing list

To post a message email:

<mailto:RPG400-L@xxxxxxxxxxxxxxxxxx>

RPG400-L@xxxxxxxxxxxxxxxxxx


To subscribe, unsubscribe, or change list options,

visit:

<https://lists.midrange.com/mailman/listinfo/rpg400-l>

https://lists.midrange.com/mailman/listinfo/rpg400-l


or email:

<mailto:RPG400-L-request@xxxxxxxxxxxxxxxxxx>

RPG400-L-request@xxxxxxxxxxxxxxxxxx


Before posting, please take a moment to review the archives

at

<https://archive.midrange.com/rpg400-l>

https://archive.midrange.com/rpg400-l

.


Please contact

<mailto:support@xxxxxxxxxxxxxxxxxxxx>

support@xxxxxxxxxxxxxxxxxxxx

for any subscription related

questions.


Help support midrange.com by shopping at amazon.com with our affiliate

link:

<https://amazon.midrange.com>

https://amazon.midrange.com



______________________________________________________________________

This email has been scanned by the Symantec Email Security.cloud service.

______________________________________________________________________





______________________________________________________________________

This email has been scanned for computer viruses. Although MSD has taken reasonable precautions to ensure no viruses are present in this email, MSD cannot accept responsibility for any loss or damage arising from the use of this email or attachments.

______________________________________________________________________

--

This is the RPG programming on IBM i (RPG400-L) mailing list

To post a message email:

<mailto:RPG400-L@xxxxxxxxxxxxxxxxxx>

RPG400-L@xxxxxxxxxxxxxxxxxx


To subscribe, unsubscribe, or change list options,

visit:

<https://lists.midrange.com/mailman/listinfo/rpg400-l>

https://lists.midrange.com/mailman/listinfo/rpg400-l


or email:

<mailto:RPG400-L-request@xxxxxxxxxxxxxxxxxx>

RPG400-L-request@xxxxxxxxxxxxxxxxxx


Before posting, please take a moment to review the archives

at

<https://archive.midrange.com/rpg400-l>

https://archive.midrange.com/rpg400-l

.


Please contact

<mailto:support@xxxxxxxxxxxxxxxxxxxx>

support@xxxxxxxxxxxxxxxxxxxx

for any subscription related questions.


Help support midrange.com by shopping at amazon.com with our affiliate link:

<https://amazon.midrange.com>

https://amazon.midrange.com




[https://www.medtronsoftware.com/img/MedtronMinilogo.bmp] Kevin Bucknum
Senior Programmer Analyst
MEDDATA / MEDTRON
120 Innwood Drive
Covington LA 70433
Local: 985-893-2550
Toll Free: 877-893-2550
https://www.medtronsoftware.com



CONFIDENTIALITY NOTICE

This document and any accompanying this email transmission contain confidential information, belonging to the sender that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled. If you are not the intended recipient, or the employee of agent responsible to deliver it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or action taken in reliance on the contents of these documents is STRICTLY PROHIBITED. If you have received this email in error, please notify the sender immediately to arrange for return or destruction of these documents.

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.