Re: Performance when using POI to create an excel workbook.

[as400tech@xxxxxxxxxxx]

> 
> ------------------------------
> 
> message: 4
> date: Fri, 17 Feb 2006 11:37:30 -0600 (CST)
> from: Scott Klement <midrange-l@xxxxxxxxxxxxxxxx>
> subject: Re: Performance when using POI to create an excel workbook.
> 
> 
> In my experience (and I know I'm going to get flak for saying this) 
> anytime Java is involved, this is the sort of performance you get.
> 
> Obviously, a hardware upgrade would help make things faster.  Not sure 
> what else would help...
> 
> ---
> Scott Klement  http://www.scottklement.com
> 
> 
> On Fri, 17 Feb 2006, as400tech@xxxxxxxxxxx wrote:
> 
> > Greetings List,
> > Using POI, I am able to create an excel workbook from my RPG program
> > that looks exactly as I want it to. The problem is that it is taking up
> > to 30 minutes to create the workbook. Is there any way to speed up the
> > creation process? I am reading a file with 3800 records and creating a
> > workbook with 14 named sheets (one for each division) on a 720 at V5R3.
> >
> > Thanks,
> >
> > Terry Anderson
> >

Scott & Leif,
That's what I was afraid of. Hopefully one of these days the powers that
be will decide to loosen the purse strings and upgrade the boxes.

Thanks,

Terry Anderson