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>
>
>