Re: STRDBG/ENDDBG required to prevent Java open exception

Sorry Peter,

Seem the link I gave you goes to nowhere.....


Here's the hole thing in text (thanks to Marco):

Hey all,
Just thought I'd let you know that I was able to work my way around this 
problem...thanks to David Hinselwood...I saw that he'd had a similar 
problem back in the day and contacted him to see if he had ever resolved 
it...he said that he created his own java program to open the spreadsheet 
instead of having RPG do it...here's his java program:

XLWorkBook.java
import java.io.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
public class XLWorkBook {
   static public HSSFWorkbook loadWB(String fileName) {
      POIFSFileSystem fs = null;
      HSSFWorkbook wb = null;
      FileInputStream infile = null;
      try {
         infile = new FileInputStream(fileName);
         fs = new POIFSFileSystem(infile);
         wb = new HSSFWorkbook(fs);
         infile.close();
      }
      catch (IOException e) {
         e.printStackTrace();
      }
      finally {
         if (infile != null) {
            try {
               infile.close();
            }
            catch (IOException e) {
               e.printStackTrace();
            }
         }
      }
   return wb;
 }
}

place this java program in the same IFS folder as the Jakarta POI jar 
files...change your current directory on the iSeries using CHGCURDIR 
DIR('/QIBM/UserData/Java400/ext/')...or wherever your POI files are...then 
compile the java program using STRQSH...in there execute the following 
command...javac /QIBM/UserData/Java400/ext/XLWorkBook.java...this will 
create your class for use in your RPGLE programs...

then, in my RPGLE program:

d openXL          pr              o   extproc(*JAVA
d                                     :'XLWorkBook'
d                                     :'loadWB')
d                                     CLASS(*JAVA:
d                                     'org.apache.poi.hssf.usermodel-
d                                     .HSSFWorkbook')
d                                     static
d  fileName                           like(jString)
...
d fileName        s                   like(jString)
...
fileName = new_String('/home/scessna/excel/May05DailyLaborHours.xls');
book = openXL(fileName);

hope this helps anyone else who was/is having the same problem as me...
> 
> 
Leif