Re: CPYPF2XLS and recent versions of POI

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!