×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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 ?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.