Re: Excel Generation Alternatives

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Paul

<verndor response>
If a commercial offering is feasible, we have our RPG2SQL Integrator 
product, which include Excel functionality. It doesn't use SQL to work 
with Excel (it could, but that is really ugly), it uses an instance of 
Excel running on a middleware PC. I'm biased and think it is easier to 
use than the Java alternatives, although probably not much compared to 
Scott's API.

Demos and evals are easily set up, you can be productive very quickly. 
Email me at vern@xxxxxxxxxxxxxxx or sales at sales@xxxxxxxxxxxxxxx or 
call 888.rjs.soft for more information.
</verndor response>

Vern (as you can tell!!)

pholm@xxxxxxxxxxxxxxxxx wrote:
>    All,
>    It seems that the POI/HSSF is somewhat fragile and cumbersome.  What
>    advantages does the RPG POI "Push" approach have over alternatives such as
>    iSeries Navigator Excel plug in or using an Excel Web query where you can
>    "pull" data into excel.  It seems the "pull" approaches allows you to
>    format cells, produce formulas, pivot tables, etc  using WYSIWYG built in
>    Excel utilities versus coding cells in RPG/Java logic?  Isn't this much
>    more productive?
>    Thanks, Paul Holm
>