|
Peter, I didn't succeed in calling JexelApi from RPG. In Rpg before calling the Workbook.createWorkbook(...) we must call the *contructor for Workbook to get an instance of Workbook. wb = Workbook(); and then we can invoke the method and get the WritableWorkbook wwb = createWorkbook(wb.outFile); Then if we want to use it with Rpg I think that the class should be: public class jxl.Workbook extends java.lang.Object { public jxl.Workbook(); because with: public abstract class jxl.Workbook extends java.lang.Object { protected jxl.Workbook(); when we invoke the *contructor from Jni it can't be found But this does not mean that it can't be done. I dind't succeed . . . If you do, let us know. Giuseppe. From: <Peter.Colpaert@xxxxxxxxxx> To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx> Sent: Monday, November 22, 2004 2:23 PM Subject: Re: RPG calling JAVA performance > Giuseppe, > > This apparently only works if the TO file for CPYFRMIMPF already exists, > which is not the case: we don't know in advance how may fields will be in > the CSV, nor which data type they will be. > > My current version supports this, but when the record count goes over > 1.000, it takes ages to generate. > > Have you tried calling JExcelApi from RPG and compared the performance to > POI? > > Even if it goes only twice as fast, we could double the record count > without suffering performance loss. > > Thanks, > > Peter Colpaert > Application Developer > Massive - Kontich, Belgium > ----- > Real developers never document. If it was hard to write, it should be > hard to understand. > ----- > > > > > "Beppe Costagliola" <beppecosta@xxxxxxxx> > Sent by: rpg400-l-bounces@xxxxxxxxxxxx > 22/11/2004 14:12 > Please respond to RPG programming on the AS400 / iSeries > > > To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx> > cc: > Subject: Re: RPG calling JAVA performance > > > Peter, > > you can upload the CSV into a table (CPYFRMIMPF) and then generate the XLS > from it. > > Giuseppe. > > ----- Original Message ----- > From: <Peter.Colpaert@xxxxxxxxxx> > To: <rpg400-l@xxxxxxxxxxxx> > Sent: Monday, November 22, 2004 1:33 PM > Subject: Re: RPG calling JAVA performance > > -- > 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. >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.