RE: Jakarta POI HSSF question...

["Gary L Peskin" <garyp@xxxxxxxxxxxx>]

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