× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. JAVA400-L
  3. May 2005

RE: Jakarta POI HSSF question...

I'm not exactly sure as to how I go about getting this to work...The 
example on the site is for someone who was having trouble getting a 
workbook created...I'm trying to open up an existing one...

if someone could help me out on how I can get this stack trace, that'd be 
great...I don't know a whole lot about java, so trying to use this in an 
RPGLE program is quite a challenge for me...I can't get this to 
compile...I did create the DebugCREATEWB in my /QIBM/UserData/Java400/ext/ 
folder on the IFS and it compiled and created the class, so I guess I'm 
not sure exactly how to go about using it...I've also got the 
poi-2.5.1-final-20040804.jar file in this IFS folder...here's the code I'm 
trying to recreate from that thread:

h dftactgrp(*no) thread(*serialize)
h option(*srcstmt:*nodebugio:*noshowcpy)
dwb               s               o   class(*JAVA:
d                                     'org.apache.poi-
d                                     hssf.usermodel.HSSFWorkbook')
dcreatewb         pr                  extproc(*java:
d                                     'DebugCREATEWB.org.apache.poi-
d                                     hssf.usermodel.HSSFWorkbook':
d                                     'createWB')
 /free
  wb = createwb();
  *inlr = *on;
 /end-free

if it helps, i'll post the actual code of what i'm trying to accomplish...

h dftactgrp(*no) bnddir('HSSF') thread(*serialize)
h option(*srcstmt:*nodebugio:*noshowcpy) bnddir('QC2LE')
 /copy qsysinc/qrpglesrc,jni
 /copy qrpglesrc,hssf_h
d book            s                   like(HSSFWorkbook)
d spreadsheet     s                   like(HSSFSheet)
 /free
  hssf_begin_object_group(100);
  monitor;    //the next line fails every time in batch but not 
interactively...
    book = hssf_open('/home/SCESSNA/excel/May05DailyLaborHours2.xls');
    monitor;
      spreadsheet = hssf_getSheet(book:'May 25');
      if spreadsheet = *null;
        spreadsheet = HSSF_newSheet(book:'May 25');
      endif;
    on-error;
      spreadsheet = HSSF_newSheet(book:'May 25');
    endmon;
  on-error;
    book = new_HSSFWorkbook();
    spreadsheet = HSSF_newSheet(book:'May 25');
  endmon;
  HSSF_save(book:'/home/SCESSNA/excel/May05DailyLaborHours2.xls');
  hssf_end_object_group();
  *inlr = *on;
 /end-free

Are you guys using Scott Klement's service program or do you have your 
own?  Thanks again for all your help...

Shane Cessna  
iSeries Programmer
iSeries WAS Administrator
North American Lighting, Inc.
(618) 662-4483 x2776
shane_cessna@xxxxxxx 



Regarding your original problem, please have a look at
http://archive.midrange.com/rpg400-l/200402/msg00301.html and then post 
the
complete stack trace.

java.io.InputStream is an abstract class that cannot be instantiated.  You
need to instantiate a concrete subclass of it like FileInputStream.

Gary

> -----Original Message-----
> From: java400-l-bounces@xxxxxxxxxxxx 
> [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> Shane_Cessna@xxxxxxx
> Sent: Thursday, May 26, 2005 12:19 PM
> To: Java Programming on and around the iSeries / AS400
> Subject: RE: Jakarta POI HSSF question...
> 
> is there a major difference between these 2 classes?
> 
> D jFileInputStream... 
> D                 S               O   CLASS(*JAVA 
> D                                     : 'java.io.FileInputStream')
> 
> D jInputStream... 
> D                 S               O   CLASS(*JAVA 
> D                                     : 'java.io.InputStream') 
> 
> Shane Cessna
> iSeries Programmer
> iSeries WAS Administrator
> North American Lighting, Inc.
> (618) 662-4483 x2776
> shane_cessna@xxxxxxx 
> 
> 
> 
> "Gary L Peskin" <garyp@xxxxxxxxxxxx>
> Sent by: java400-l-bounces@xxxxxxxxxxxx
> 05/26/2005 01:50 PM
> Please respond to
> Java Programming on and around the iSeries / AS400 
> <java400-l@xxxxxxxxxxxx>
> 
> 
> To
> "'Java Programming on and around the iSeries / AS400'" 
> <java400-l@xxxxxxxxxxxx>
> cc
> 
> Subject
> RE: Jakarta POI HSSF question...
> 
> 
> 
> 
> 
> 
> Hmmm.  I'm looking this up.  In the meantime, can you please 
> do a WRKUSRJOB and see if there is a job starting with a Q 
> under your user name that might have spool files with the stack trace?
> 
> Thanks,
> Gary
> 
> > -----Original Message-----
> > From: java400-l-bounces@xxxxxxxxxxxx
> > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> > Shane_Cessna@xxxxxxx
> > Sent: Thursday, May 26, 2005 11:33 AM
> > To: Java Programming on and around the iSeries / AS400
> > Subject: RE: Jakarta POI HSSF question...
> > 
> > Gary,
> > 
> > Sorry, all it's got is this:
> > 
> >                          Work with Job Spooled Files
> > 
> > Job:   JPDLHS2        User:   SCESSNA        Number:   788748 
> > 
> > Type options, press Enter. 
> >   1=Send   2=Change   3=Hold   4=Delete   5=Display 
> > 6=Release 7=Messages
> > 
> >   8=Attributes        9=Work with printing status 
> > 
> >                  Device or                       Total   Current 
> > Opt  File        Queue       User Data   Status  Pages 
> > Page   Copies 
> > 
> >      QPJOBLOG    QEZJOBLOG   JPDLHS2      RDY        3 
> >         1
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> >  Bottom
> > Parameters for options 1, 2, 3 or command ===> 
> > F3=Exit   F10=View 3   F11=View 2   F12=Cancel   F22=Printers 
> >   F24=More
> > keys
> > 
> > Shane Cessna
> > iSeries Programmer
> > iSeries WAS Administrator
> > North American Lighting, Inc.
> > (618) 662-4483 x2776
> > shane_cessna@xxxxxxx
> > 
> > 
> > 
> > "Gary L Peskin" <garyp@xxxxxxxxxxxx>
> > Sent by: java400-l-bounces@xxxxxxxxxxxx
> > 05/26/2005 01:26 PM
> > Please respond to
> > Java Programming on and around the iSeries / AS400 
> > <java400-l@xxxxxxxxxxxx>
> > 
> > 
> > To
> > "'Java Programming on and around the iSeries / AS400'" 
> > <java400-l@xxxxxxxxxxxx>
> > cc
> > 
> > Subject
> > RE: Jakarta POI HSSF question...
> > 
> > 
> > 
> > 
> > 
> > 
> > They should be spool files with the batch job.  Try doing a 
> WRKSBMJOB 
> > and then selecting the job and then option 4.
> > 
> > Gary
> > 
> > > -----Original Message-----
> > > From: java400-l-bounces@xxxxxxxxxxxx 
> > > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> > > Shane_Cessna@xxxxxxx
> > > Sent: Thursday, May 26, 2005 10:58 AM
> > > To: Java Programming on and around the iSeries / AS400
> > > Subject: RE: Jakarta POI HSSF question...
> > > 
> > > Gary,
> > > 
> > > How do I go about accessing these spool files?
> > > 
> > > Shane Cessna
> > > iSeries Programmer
> > > iSeries WAS Administrator
> > > North American Lighting, Inc.
> > > (618) 662-4483 x2776
> > > shane_cessna@xxxxxxx
> > > 
> > > 
> > > 
> > > "Gary L Peskin" <garyp@xxxxxxxxxxxx> Sent by: 
> > > java400-l-bounces@xxxxxxxxxxxx
> > > 05/26/2005 09:55 AM
> > > Please respond to
> > > Java Programming on and around the iSeries / AS400 
> > > <java400-l@xxxxxxxxxxxx>
> > > 
> > > 
> > > To
> > > "'Java Programming on and around the iSeries / AS400'" 
> > > <java400-l@xxxxxxxxxxxx>
> > > cc
> > > 
> > > Subject
> > > RE: Jakarta POI HSSF question...
> > > 
> > > 
> > > 
> > > 
> > > 
> > > 
> > > It would be helpful if we could see the full stack trace for the 
> > > IOException.  There should be spool files created for
> > System.err and
> > > System.out that would show this.
> > > 
> > > Gary
> > > 
> > > > -----Original Message-----
> > > > From: java400-l-bounces@xxxxxxxxxxxx 
> > > > [mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of 
> > > > Shane_Cessna@xxxxxxx
> > > > Sent: Thursday, May 26, 2005 7:01 AM
> > > > To: Java Programming on and around the iSeries / AS400
> > > > Subject: RE: Jakarta POI HSSF question...
> > > > 
> > > > I've even tried hardcoding the .xls file name and
> > > spreadsheet name and
> > > > still get the same results...
> > > > 
> > > > /free
> > > >  hssf_begin_object_group(100);
> > > >  monitor;
> > > >    book =
> > > hssf_open('/home/scessna/excel/May05DailyLaborHours2.xls');
> > > >    monitor;
> > > >      spreadsheet = hssf_getSheet(book:'May 25');
> > > >      if spreadsheet = *null;
> > > >        spreadsheet = HSSF_newSheet(book:'May 25');
> > > >      endif;
> > > >    on-error;
> > > >      spreadsheet = HSSF_newSheet(book:'May 25');
> > > >    endmon;
> > > >  on-error;
> > > >    book = new_HSSFWorkbook();
> > > >    spreadsheet = HSSF_newSheet(book:'May 25');  endmon; 
> > > > HSSF_save(book:'/home/scessna/excel/May05DailyLaborHours2.xls');
> > > >  hssf_end_object_group();
> > > >  *inlr = *on;
> > > > /end-free
> > > > 
> > > > Shane Cessna
> > > > iSeries Programmer
> > > > iSeries WAS Administrator
> > > > North American Lighting, Inc.
> > > > (618) 662-4483 x2776
> > > > shane_cessna@xxxxxxx
> > > > 
> > > > 
> > > > 
> > > > michael@xxxxxxxxxxxxxxxxxx
> > > > Sent by: java400-l-bounces@xxxxxxxxxxxx
> > > > 05/26/2005 08:43 AM
> > > > Please respond to
> > > > Java Programming on and around the iSeries / AS400 
> > > > <java400-l@xxxxxxxxxxxx>
> > > > 
> > > > 
> > > > To
> > > > Java Programming on and around the iSeries / AS400 
> > > > <java400-l@xxxxxxxxxxxx> cc
> > > > 
> > > > Subject
> > > > RE: Jakarta POI HSSF question...
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > 
> > > > What's the actual error? What does %status show? See
> > > anything in the
> > > > job log?
> > > > 
> > > > > -------- Original Message --------
> > > > > Subject: RE: Jakarta POI HSSF question...
> > > > > From: Shane_Cessna@xxxxxxx
> > > > > Date: Thu, May 26, 2005 9:35 am
> > > > > To: Java Programming on and around the iSeries / AS400 
> > > > > <java400-l@xxxxxxxxxxxx>
> > > > > 
> > > > > sorry guys, I tried that in the CL...still get the same
> > > > results...if it
> > > > > helps, here's my source...the hssf_h & HSSF binding
> > > > direcotry is the
> > > > stuff
> > > > > that Scott Klement put in a few Club Tech newsletters for
> > > > > 
> > > > iSeriesNetwork.com...http://www.iseriesnetwork.com/noderesourc
> > > > es/code/clubtechcode/ExcelCrtDemo.zip
> > > > > 
> > > > > JPTESTC2 - CLP
> > > > > PGM
> > > > > CHGCURDIR  DIR('/')
> > > > > ADDENVVAR  ENVVAR(CLASSPATH) +
> > > > >              VALUE('.:QIBM/UserData/Java400/ext/poi-2.5.+
> > > > >              1-final-20040804.jar') REPLACE(*YES)
> > > > > CALL       PGM(JPTEST2)
> > > > > ENDPGM
> > > > > 
> > > > > JPTEST2 - RPGLE
> > > > > h dftactgrp(*no) bnddir('HSSF') thread(*serialize) h
> > > > > option(*srcstmt:*nodebugio:*noshowcpy) bnddir('QC2LE')  /copy 
> > > > > qsysinc/qrpglesrc,jni  /copy qrpglesrc,hssf_h
> > > > >  //---------------------------------------------
> > > > >  // Data Structures
> > > > >  //---------------------------------------------
> > > > > d                 ds 
> > > > > dmonthsshort                    48a   Inz('Jan +
> > > > > d                                          Feb +
> > > > > d                                          Mar +
> > > > > d                                          Apr +
> > > > > d                                          May +
> > > > > d                                          Jun +
> > > > > d                                          Jul +
> > > > > d                                          Aug + 
> > > > > d                                          Sep + 
> > > > > d                                          Oct + 
> > > > > d                                          Nov + 
> > > > > d                                          Dec ') 
> > > > > dmonthshort                      4a   dim(12) 
> > overlay(monthsshort)
> > > > > d                 ds 
> > > > > d year4                   1      4  0 
> > > > > d year2a                         2a   overlay(year4:3) 
> > > > > 
> > //---------------------------------------------------------------
> > > > >  // Standalones & Constants
> > > > > 
> > //---------------------------------------------------------------
> > > > > d book            s                   like(HSSFWorkbook) 
> > > > > d spreadsheet     s                   like(HSSFSheet) 
> > > > > d enddate         s               d 
> > > > > d endday          s              2p 0 
> > > > > d dayname2        s              6a   varying 
> > > > > d attachment      s             50a 
> > > > > 
> //------------------------------------------------------------
> > > > >  // Mainline
> > > > > 
> //------------------------------------------------------------
> > > > >  /free 
> > > > >   enddate = %date() - %days(1); 
> > > > >   endday = %subdt(enddate:*days); 
> > > > >   year4 = %subdt(enddate:*years); 
> > > > >   hssf_begin_object_group(100); 
> > > > >   attachment = '/home/scessna/excel/' + 
> > > > >                %trim(monthshort(%subdt(enddate:*months))) + 
> > > > >                %trim(year2a) + 'DailyLaborHours2.xls'; 
> > > > >   dayname2 = 
> %trim(monthshort(%subdt(enddate:*months))) + ' ' +
> > > > >              %char(endday); 
> > > > >   monitor; 
> > > > >     book = hssf_open(%trim(attachment));    <-- this never 
> > > > gets found &
> > > > > jumps to the on-error
> > > > >     monitor; 
> > > > >       spreadsheet = hssf_getSheet(book:%trim(dayname2)); 
> > > > >       if spreadsheet = *null; 
> > > > >         spreadsheet = HSSF_newSheet(book:%trim(dayname2));
> > > > >       endif; 
> > > > >     on-error; 
> > > > >       spreadsheet = HSSF_newSheet(book:%trim(dayname2)); 
> > > > >     endmon; 
> > > > >   on-error; 
> > > > >     book = new_HSSFWorkbook();
> > > > <-- here is
> > > > > where it jumps to...
> > > > >     spreadsheet = HSSF_newSheet(book:%trim(dayname2)); 
> > > > >   endmon; 
> > > > >   HSSF_save(book:%trim(attachment)); 
> > > > >   hssf_end_object_group(); 
> > > > >   *inlr = *on;
> > > > >  /end-free
> > > > > 
> > > > > if you guys can find anything wrong with my code, 
> please let me 
> > > > > know...thanks again...
> > > > > 
> > > > > Shane
> > > > > 
> > > > > 
> > > > > Hi,
> > > > > 
> > > > > here is what I do in a CL before I call the RPGLE 
> (with Jakarta
> > > > > POI):
> > > > > 
> > > > > CHGCURDIR  DIR('/jakartapoi')
> > > > > ADDENVVAR  ENVVAR(CLASSPATH) +
> > > > > VALUE('.:/jakartapoi:/jakartapoi/jakartapoi151.jar') + 
> > > > >              REPLACE(*YES)
> > > > > 
> > > > > Regards,
> > > > > Magne
> > > > > 
> > > > > 
> > > > > Date: Wed, 25 May 2005 10:55:39 -0500
> > > > > From: Shane_Cessna@xxxxxxx Add To Address Book
> > > > > Subject: RE: Jakarta POI HSSF question... 
> > > > > To: Java Programming on and around the iSeries / AS400 
> > > > > <java400-l@xxxxxxxxxxxx>
> > > > > 
> > > > > 
> > > > > 
> > > > > Michael,
> > > > > 
> > > > > Where can I find this CLASSPATH parameter?...
> > > > > 
> > > > > Shane Cessna
> > > > > iSeries Programmer
> > > > > iSeries WAS Administrator
> > > > > North American Lighting, Inc.
> > > > > (618) 662-4483 x2776
> > > > > shane_cessna@xxxxxxx

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 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.