RE: Printing a report in MS excel.

How Excel do you want to go?  A tab delimited file?  Or a full blown .xls
file with all the formatting to go with it?

Either way, look up Scott Klement's, IFS api's examples, or his POI hssf
code, both can be done within RPG.

I use both... With great results.

And as always his code if excellent.

Tim

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Jake M
Sent: Friday, April 07, 2006 2:14 PM
To: RPG programming on the AS400 / iSeries
Subject: Printing a report in MS excel.

All;

I have a RPGLE program which produces a report. Is there any way I can
produce the report in MS Excel  rather than a  report using O - Specs. I
could go the java route and use jxl or hssf as an API but I do not want to
rewrite the whole code in java again. Any suggestions/input will be much
appreciated.

Cheers,

Jake.