Re: CPYPF2XLS and recent versions of POI

[Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Thanks, Bryan

That confirms my findings - I think I found a similar page about this.

I also saw something about a different method, on the HSSFFont, called 
setCharSet. This seems the more appropriate place to put this, anyhow.

But fortunately this isn't necessary for standard stuff.

CPYPF2XLS still seems to suffer from really slow performance. This seems 
somewhat in common with the other POI-based RPG-call solutions.

The SQL2JXL tool from Giuseppe Costagliola is really fast - it uses a 
different Java class - JExcelAPI - and he has written a true Java class 
that uses JDBC to process a specified SELECT statement. A problem with 
JExcelAPI, so far as I can tell, is that it does not support the new 
format for Excel and POI does.

Makes me wonder about extra overhead, if any, when running Java methods 
from RPG.

Vern

On 4/8/2013 4:41 PM, Bryan Dietz wrote:
> i tried with POI 3.6 and got the same error.
>
> I found the following:
> http://community.jaspersoft.com/jasperreports-library/issues/3183-0
>
> <snip>
>
> The deprecated method has been removed into the latest version of POI,
> as of 3-Jan-06 POI now automatically handles Unicode without forcing the
> encoding.
>
> Commenting the affected code line every things work correctly.
>
> </snip>
>
>
>
> so I just commended out the lines(6) containing:
>
> setEncoding(cell:1);
>
>
> recompiled and it worked for me when testing with the QIWS/QCUSTCDT file.
>
>
> Bryan
>
>
> Vern Hamberg said the following on Mon, 4/8/2013 2:12 PM:
> > Hi all
> >
> >
> >
> > Am looking at Peter Colpaert's CPYPF2XLS - the version I downloaded does not work with recent versions of POI. It is calling a SetEncoding method of a cell , and that doesn't exist anymore - apparently replaced by the SetCharSet method of a font.
> >
> >
> >
> > If Peter is listening, do you have a newer version? I know, you give us all the source - thank you, BTW - but I'd just as soon let someone else do this one!
> >
> >
> >
> > I'm using POI 3.9 - it still works with Scott's POI stuff, which is tested at 3.6.
> >
> >
> >
> > Cheers
> >
> > Vern - not at COMMON since a long time!