RE: EXCEL From RPG applications

Thanks Tim.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of tim
Sent: 15 June 2007 3:15 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: EXCEL From RPG applications


You can ignore the ut999copy and amspgmcopy copy books. They are our shops
custom routines.

Prototypeb and usec come from library CGIDEV2 which is what drives this
whole beast (http://www.easy400.net/cgidev2/start). Visit this link if you
don't have cgidev2 installed and install it. The code now belongs is
supported by IBM since they refused to make it an open source project.



-----Original Message-----
From: rpg400-l-bounces+tim2006=comcast.net@xxxxxxxxxxxx
[mailto:rpg400-l-bounces+tim2006=comcast.net@xxxxxxxxxxxx] On Behalf Of
Emmanuel Zannis
Sent: Friday, June 15, 2007 10:04 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: EXCEL From RPG applications

Thanks to Tim And to Jonathan for the copy suggestion.

One question Tim, breaking it into smaller questions what is in:

/copy qrpglesrc,prototypeb
/copy qrpglesrc,usec
/copy ntcoll/allsrc,ut9999copy
/copy ntcoll/allsrc,amspgmcopy

Sorry for the persistence.

Thanks

Emmanuel

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of tim
Sent: 15 June 2007 2:56 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: EXCEL From RPG applications


Thanks Jonathan...


http://code.midrange.com/index.php?id=6a6df01709




-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jonathan Mason
Sent: Friday, June 15, 2007 9:46 AM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: EXCEL From RPG applications

Tim

You can post source code examples at http://code.midrange.com and then
include the generated link in your message to the list.

Jonathan

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of tim
Sent: 15 June 2007 14:33
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: EXCEL From RPG applications

Here are some examples. Don't know if this forum accepts attachments. If
not, can try another way.

Happy cgi'ing

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Emmanuel Zannis
Sent: Friday, June 15, 2007 8:23 AM
To: RPG programming on the AS400 / iSeries
Subject: RE: EXCEL From RPG applications

Hi Guys,

Any examples on how you do that?

Thanks

Emmanuel



-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]On Behalf Of tim
Sent: 15 June 2007 1:21 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: RE: EXCEL From RPG applications


I use CGIDEV2 to create my spreadsheets. To do this, I first save the
"template" of my sheet as an xml. Then I use the cgidev2 procudures to fill
in the blanks. Works very nicely. If you need some coding examples, let me
know.

Tim

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of David Foxwell
Sent: Friday, June 15, 2007 5:14 AM
To: rpg400-l@xxxxxxxxxxxx
Subject: EXCEL From RPG applications

Hi.

Our programs are increasingly being used to generate EXCEL spreadsheets
instead of reports. Until recently, we just called a program to copy the i5
file to the IFS as a CSV file.

We now have a small JAVA application that converts the CSV to XLS.

Added to that, we use RPG and JAVA to send the file automatically by email
to the user.

Now I have an application that sends 3 files. The result is 3 different
spreadsheets. I'm having a few problems because I'm having to depend on JAVA
programmers when things don't work properly.

As an alternative, I have created a spreadsheet with a macro that imports
the 3 files as 3 sheets. That way the user only has one spreadsheet to open.


I get the results without depending on any JAVA application and I have
complete control over the presentation, etc.

The problem : I'm generating around 20 000 lines and the macro takes a
minute and a half to work. This is quicker than using the JAVA application
but that runs in batch.

How do I get my spreadsheet to the user only after the macro has been
executed ?


TIA