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>
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.