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 
                        Sent: Wed 3/17/2004 3:04 PM 
                        To: midrange-l@xxxxxxxxxxxx 
                        Subject: MIDRANGE-L Digest, Vol 3, Issue 403

                        Send MIDRANGE-L mailing list submissions to
                        To subscribe or unsubscribe via the World Wide Web, 
                        or, via email, send a message with subject or body 
'help' to
                        You can reach the person managing the list at
                        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:
                        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.
                        > 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>

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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