Re: Excel - Rpg

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Prevesh

<vendor response>
If you are willing to look at a commercial offering, we at RJS 
Software have the RPG2SQL Integrator product - it has not just SQL 
functionality, but also Excel functionality - with this I believe you 
could accomplish all you are trying to do. Any Excel function can be 
called from it, so these settings should be possible to do.

If interested, please contact me at vern@xxxxxxxxxxxxxxx - and look 
at our site at www.rjssoftware.com
</vendor response>

Regards
Vern

At 07:08 AM 9/5/2007, you wrote:

> Hi,
>
> I have been assigned a project to create an Excel Spreadsheet using
> RPG, I have just finished my first RPGLE program to write directly to an
> Excel Spreadsheet guided by the fantastic articles by Scott Klement and
> Zach's answer to the binding directory mystery both of which are listed
> below, I am quite pleased that everything works! However-I am having a
> problem when I print the spreadsheet, is there a way to default the
> print setup with regards to "Orientation Landscape" ; "Scaling Adjust to
> 81%" ; "Paper Size A4(210x297mm)" "Top Left and Right Margins to 0" and
> "Print Gridlines" from my RPGLE or any other tool that can be called
> from my RPGLE?
> I do know of an Active X Control package that runs in SQL?
>
>
> Prevesh Kuni
> Developer
> Smollan Group
> (011) 640 8154
> kunip@xxxxxxxxxxxxxx