Porting a C or C++ library to ILE C/C++ to be called by RPG would be significantly more performant than Java, and not Goldbergian at all. I regularly call C procedures from RPG. I know I mentioned PASE and Qshell, but if there is source that can be converted to a service program, that would be the best of all worlds. As far as Python goes, I do not know much about it other than it cares about proper indenting to know which statements go with which control blocks. Can it be called by a program object? Can it call into a program object, or better a service program? On the other hand I know Java well enough that I could write Java routines to minimize the number of calls an RPG program would need to do to write a spreadsheet were performance a problem.
Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx
-----John Yeung <gallium.arsenide@xxxxxxxxx> wrote: -----
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
From: John Yeung <gallium.arsenide@xxxxxxxxx>
Date: 02/29/2016 05:34PM
Subject: Re: Update Excel with RPG
On Mon, Feb 29, 2016 at 4:28 PM, Mark Murphy/STAR BASE Consulting Inc.
<mmurphy@xxxxxxxxxxxxxxx> wrote:
But it works, and there is no comparable RPG library. It would take quite a bit of work to make one that has the capabilities of POI.
Possibly nothing comparable; definitely nothing that is both
comparable and publicly available. ;)
Scott wrote an all-RPG writer for his own use. I don't remember if he
said he included read capability as well. In any case, I would be very
surprised and impressed if it were as feature-complete as POI. As
you've implied, POI's capabilities are extensive.
If someone knows of something that is comparable, let me know. Maybe if there are enough interested parties, we could port something. Maybe there is something written in C or C++ out there that is compiled for PASE, or that can be ported to qshell?
If we assume writing a pure-RPG equivalent to POI is out of the
question because it would require exorbitant effort (not a bad
assumption, in my book), then the best answer left for reducing the
Goldbergian nature of calling POI via RPG is to learn Java and use POI
directly from Java. Porting anything else, with the purpose of using
RPG to call it, would just be substituting one Rube Goldberg machine
for another.
That said, I think there are better options than Java+POI. I have been
plugging Python and XlsxWriter, xlrd, and OpenPyXL for quite a long
time now. Some combination of those packages will provide more than
enough functionality for most shops. In particular, XlsxWriter is an
extremely capable pure writer, even more capable than POI in some
areas, such as charts.
I will say POI is *on balance* more complete than any of the Python
packages (or indeed, probably anything out there for any language),
but I suspect most shops only use a fraction of what POI can do. Plus,
POI is just not as easy or as pleasant to use as the Python options,
if you're starting from zero knowledge of both Java and Python.
John Y.
midrange.com
