Jul 10, 2000 - implementing J.D. Edwards OneWorld on AS/400. Internal architecture, its building blocks and basics on how. Stored as ASCII PDF members. Export grid records to other applications, such as Microsoft Excel. These Excel tutorials for beginners include screenshots and examples with detailed step-by-step instructions. Follow the links below to learn everything you need to get up and running with Microsoft's popular spreadsheet software.

Dear all, Hope evry1 is doing great. We have a requirement, where in the AS400 spool file (report) needs to be converted to a formatted excel sheet and mailed to the respective people. We have designed the layout of the report using an externally described printer file ==> We have developed a RPG program for this 2. The AS400 spool (report) is generated.

==> Output of RPG program 3. We need to convert it to a formatted excel sheet ==> 4. We need to mail this as an attachment to the required people ==> keep the document in IFS and use SNDDST to mail the attachment. I have attached a sample of how the excel sheet should come up. Regards, Manty. Re: How to convert a AS400 spool file (report) to a formatted excel sheet? As always Birgitta is right on.

I have been building all of my reports with 3 options. • Printing regular report • Email as PDF • Email as CSV For printing it easy.just create print file and go.

The PDF I use the tool from this site to convert to PDF then I have a procedure that used the mail API to email. The csv file I use SQL to create a temp global file and populate it with inserts at the detail print line in RPG. Then i can use CPYTOIMPF to get sql table to csv file on IFS. I can do multiple CSV files now that I have the Zip function down. -- Once again using mail API I can email back to user.