Re: Using POI Java Classes

[MWalter@xxxxxxxxxxxxxxx]

Sure:

         qualFileName = '/Public/' + %trim(getMthDesc(fclmo:'F':'L')) +
           %subst(%char(fclyr):3:2) + 'GL.XLS';

         // save the spreadsheet
         HSSF_save(book:qualFileName);


Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


                                                                           
             Scott Klement                                                 
             <rpg400-l@scottkl                                             
             ement.com>                                                 To 
             Sent by:                  RPG programming on the AS400 /      
             rpg400-l-bounces@         iSeries <rpg400-l@xxxxxxxxxxxx>     
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             05/31/2005 12:15          Re: Using POI Java Classes          
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           





Hi Mark,

Sounds like the spreadsheet isn't being closed properly. Can we see the
code that you're using to close it?

---
Scott Klement  http://www.scottklement.com




On Tue, 31 May 2005 MWalter@xxxxxxxxxxxxxxx wrote:

> Ok,
>
> I've been very successful at using the HSSF classes to create
spreadsheets
> from within RPG. But, I have found a couple of caveats.
>
> 1) If you create a workbook in one job, then use hssf_open to try to add
> another worksheet within another job, you get an ioexception.
> 2) If you create a workbook and save it. Then use hssf_open to try to add
> another worksheet from within the same job, the worksheet is added, but
any
> cell formatting is ignored.
>
> Has anyone else experienced these little bits of annoyance?
>
> Thanks,
>
> Mark
>
> Mark D. Walter
> Senior Programmer/Analyst
> CCX, Inc.
> mwalter@xxxxxxxxxx
> http://www.ccxinc.com
>
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.