Spool output in Excel sheet format

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

We do that. It works.

Rob