TechTip: Excel on the Fly
  by Giuseppe Costagliola

The HSSF APIs make creating spreadsheets a breeze!

Very nice tool from McPressOnLine

Best regards,


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

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 

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.
> hogal/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,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

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