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