Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Spool output in Excel sheet format

Former Member
0 Kudos

Hi,

We have background job , which creates a spool output in Internet Explorer format. Customer needs this in Excel format.

Wondering, if any authorizations to be changed for file type? or this is a set in program level?

Thanks,

Sam

3 REPLIES 3

Former Member
0 Kudos

You can't create an excel file on the presentation server in background.

You could do something like save the data for the file to a z table and have another program that the user runs that reads the data and creates the spreadsheet.

Rob

0 Kudos

Thanks Rob.. Currently the customer email address is added to "Spool list Recipient" in SM37. This way, spool output is sent to customer through email. Currently it is in HTML format.

Based on your suggestion, the data should be sent to a Z-table and then another program query the table and save it in Excel format?

Thanks,

Sam

0 Kudos

We do that. It works.

Rob