Re: data entry from excel workbook

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

If you do decide to try this in RPG, my recommendation would be:

1) Set up a web page.  Don't try to do this in green screen!  Have an 
upload box/button on the site so you can upload the excel spreadsheet 
directly into the RPG program from the user's PC hard drive.

2) Use my XLPARSE (Event-style) tool that's based on POI.  It'll run 
through the whole spreadsheet and output just the data values.  This 
uses the least memory and runs the fastest of the POI-based methods.

3) Run the POI stuff in it's own job, and control it with a data queue, 
so the same POI instance can be shared by other jobs.  This makes it 
much easier to do stuff like control the classpath, etc

Reading Excel may be easier in python... but once you have the data and 
need to put it into your databases, I suspect that part will be easier 
in RPG.

These are just random thoughts... but I hope they are useful.

On 5/3/2013 8:50 AM, Gary Thompson wrote:
> John,
> Thank you.
> I expected I would be looking at Scott's stuff.
> But, I want to investigate Python - any hints for starters ?