RE: Using POI Java Classes

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

Even worse....I can do it using embedded SQL to dynamically put all of it 
together....

I wrote an embedded SQL process to "wrap-around" the HSSF service program Scott 
provided.  So I have a command interface I pass the file & lib to the command & 
leave it to the machine to do the grunt work.  Why write 5 billion programs 
using the service program when it can be done in one shot??? 


Thanks,
Tommy Holden


-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Beppe Costagliola
Sent: Tuesday, May 31, 2005 10:04 AM
To: RPG programming on the AS400 / iSeries
Subject: Re: Using POI Java Classes


Do you mean that you can create say a 20,000 x 30 with RPG+POI in a
reasonable time ?

----- Original Message ----- 
From: "Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>
To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
Sent: Tuesday, May 31, 2005 4:36 PM
Subject: RE: Using POI Java Classes


> Also meant to mention that some of the spreadsheets created contain up to
50 sheets with various number of rows.  I can't see any limitations or
issues with more than 1000 rows...actually I think it performs rather
nicely.  This process can generate the entire workbook in less than 2
minutes & that's including all processes to build the work data for which
the sheets are crated from..
>
> Thanks,
> Tommy Holden
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Holden Tommy
> Sent: Tuesday, May 31, 2005 9:33 AM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: Using POI Java Classes
>
>
> I have used this extensively & have not noted any performance issues with
mixed RPG-Java.  & Yes I am using Scott's HSSF service programs.
>
> Thanks,
> Tommy Holden
>
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx
> [mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of Fisher, Don
> Sent: Tuesday, May 31, 2005 9:27 AM
> To: 'RPG programming on the AS400 / iSeries'
> Subject: RE: Using POI Java Classes
>
>
> Sorry about the blank message folks.
>
> Why do you say mixed RPG and Java is only good for small spreadsheets?
Are
> there performance issues?
>
> Thanks.
>
> Donald R. Fisher, III
> Project Manager
> Roomstore Furniture Company
> (804) 784-7600 extension 2124
> DFisher@xxxxxxxxxxxxx
>
> <clip>
> RPG is good only for small xls (say 1,000 rows)
> and useless mof medium-big sheets.
> <clip>
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
> -- 
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>