TechTip: Excel on the Fly by Giuseppe Costagliola The HSSF APIs make creating spreadsheets a breeze! http://www.mcpressonline.com/mc/1@xxxxxxxxxxxxxxxxx@.6ae8269f Very nice tool from McPressOnLine Best regards, Vengoal -----Original Message----- From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement Sent: Thursday, March 18, 2004 3:47 AM To: Midrange Systems Technical Discussion 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?î ask "reasonable?" > My customer and I will work that out. > > http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0402b > hogal/index.html > <http://www-106.ibm.com/developerworks/db2/library/techarticle/dm-0402bhogal/index.html> > > Does anyone have any detailed information on using Apache?î 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?î working on a V5R2 box. Any help is > appreciated. > > David Smith > > iSeries Consultant > > dsmith@xxxxxxxxxx > > <mailto:h@xxxxxxxxxx> > > _______________________________________________ This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.