Re: Create Excel spreadsheet from RPGLE

[Tony Carolla <carolla@xxxxxxxxx>]

On 6/1/05, Jeffrey Young <cooljeff913@xxxxxxxxx> wrote:
> 
> What I am looking for is a solution that will enable me to create report 
> headings and column formating in a spreadsheet from an AS/400 file.
> I saw an article a while ago on how to do this with API's, but do not 
> remember where.


You can do this using my method (see earlier attachment). You can set up a 
table header, with as many lines as necessary, and with each heading 
spanning however many columns as necessary. You can adjust the font size, 
change the color of the lettering, the table cells, and the background. You 
can use formulas, in case you have accountants that want to play with the 
figures, and have the sum change. You can format the columns, by using 
%EDITC(), and place the text results in the table cells. You can even use 
graphics, if they are pre-made and their path is accessible from the user's 
desktop (You can embed the path in the HTML). Anything you can do on a web 
page with a table, you can do using my method. And Excel opens it up because 
it has an '.XLS' extension, mapping the table to a worksheet.