EXCEL POI HSSF RPGLE

["Smith, Dave" <DSmith@xxxxxxxxx>]

I am a member and that is exactly what I was looking for.    THANK YOU!!!!!!

                        -----Original Message----- 
                        From: midrange-l-bounces@xxxxxxxxxxxx on behalf of 
midrange-l-request@xxxxxxxxxxxx 
                        Sent: Wed 3/17/2004 3:04 PM 
                        To: midrange-l@xxxxxxxxxxxx 
                        Cc: 
                        Subject: MIDRANGE-L Digest, Vol 3, Issue 403
                        
                        

                        Send MIDRANGE-L mailing list submissions to
                                midrange-l@xxxxxxxxxxxx
                        
                        To subscribe or unsubscribe via the World Wide Web, 
visit
                                
http://lists.midrange.com/mailman/listinfo/midrange-l
                        or, via email, send a message with subject or body 
'help' to
                                midrange-l-request@xxxxxxxxxxxx
                        
                        You can reach the person managing the list at
                                midrange-l-owner@xxxxxxxxxxxx
                        
                        When replying, please edit your Subject line so it is 
more specific
                        than "Re: Contents of MIDRANGE-L digest..."
                        
                        
                        Today's Topics:
                        
                        from: Scott Klement <klemscot@xxxxxxxxxxxx>
                        subject: Re: EXCEL POI HSSF RPGLE
                        
                        
                        I wrote an article on parsing spreadsheets using 
POI/HSSF for the iSeries
                        Network's Club Tech iSeries Programming Tips 
newsletter. There is a
                        service program included with the article that does 
most of the
                        grunt work for you -- you just have to provide some RPG 
routines to handle
                        the data that's pulled out of the spreadsheet.
                        
                        If you're a member of the iSeries Network, you can read 
that article here:
                        
http://www.iseriesnetwork.com/clubtech/index.cfm?fuseaction=ShowNewsletterIssue&ID=17839
                        
                        If you're not a member, you can create a free 
"Associate" account to read
                        the article.
                        
                        
                        On Wed, 17 Mar 2004, Smith, Dave wrote:
                        
                        > I am researching methods for a customer to 
automatically retrieve date
                        > from excel spreadsheets (XLS) into my iSeries 
database. I will have 200+
                        > XLS all formatted the same but uniquely named that 
come in on a monthly
                        > basis. I can easily get the XLS over to my IFS and 
now I want to read
                        > specific cells of each XLS to update my database 
file. I will not be
                        > updating the spreadsheets, just reading from them.
                        >
                        > The POI and HSSF method shown below looks like the 
way to go if I can
                        > implement it in a reasonable amount of time. 
DonÃâât ask "reasonable?"
                        > My customer and I will work that out.
                        >
                        > 
http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0402bhogal/index.html
                        > 
<http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0402bhogal/index.html>
                        >
                        > Does anyone have any detailed information on using 
ApacheÃââs POI on the
                        > iSeries, the set up they had go through, the problems 
they have
                        > encountered, etc.? Are there any other ways that 
people are doing this
                        > on a regular basis? IÃââm working on a V5R2 box. 
Any help is
                        > appreciated.
                        >
                        > David Smith
                        >
                        > iSeries Consultant
                        >
                        > dsmith@xxxxxxxxxx
                        >
                        > <mailto:h@xxxxxxxxxx>