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.

This thread ...

Replies:

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.