Re: Improving Excel generation performance through calling Java

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

hi Darren,

1) Your Java method is declared as static.  Therefore, you'll also need 
to put 'static' on the RPG prototype.

2) You have the 'row' parameter commented-out in your RPG prototype.

3) Your method is named 'main', which normally has a special purpose in 
Java.  I don't know if it's possible to use a method named 'main', this 
way...  did the Java code compile without errors?

4) is the directory containing the .class file in your CLASSPATH?



On 3/22/2010 9:07 AM, darren@xxxxxxxxx wrote:
> I'm still on a quest to improve our Excel document creation performance.
> I've created the following java program to perform what Scott Klement's RPG
> service program did, to create a text cell, but doing the 4 steps in Java
> to hopefully get improved performance.  I'm having problems either
> specifying the java header stuff correctly, or in specifying the RPG
> prototype, because I get a java.lang.NoClassDefFoundError: HSSFtext error
> when calling a program using the prototype.  Can anyone see where I'm going
> wrong?
>
> Java program:
> import org.apache.poi.hssf.usermodel.HSSFCell;
> import org.apache.poi.hssf.usermodel.HSSFCellStyle;
> import org.apache.poi.hssf.usermodel.HSSFRow;
> import org.apache.poi.hssf.usermodel.HSSFRichTextString;
>
> public final class HSSFtext {
> 	public static void main(HSSFRow Row, int Col, String value,
> HSSFCellStyle style ) {
>
>          HSSFCell Cell = Row.createCell(Col);
>          Cell.setCellType(1);
>          //wwStr = new_String(peString);
>          Cell.setCellValue(new HSSFRichTextString(value));
>          Cell.setCellStyle(style);
>
>          }
> }
>
>
>
> RPG prototype:
>       D hssf_textz...
>       D                 PR                  EXTPROC(*JAVA
>       D                                     :'HSSFtext'
>       D                                     :'main')
>       D*  peRow                             like(HSSFRow)
>       D   peCol                             like(jshort) value
>       D   peString                          like(jstring)
>       D   peStyle                           like(HSSFCellStyle)