Excel generation through batchjob

[former_member1124549]

We would like to investigate technical feasibility of creating a SAP batch job that can run a query, And export the results to an excel spreadsheet and save to a location. Can any one me on this.

[i040689]

Hi,

The default output format on the job/process definition level is used to set

the mime-type used to open a file. It does not convert a file in text format to CSV format. The file needs to

be generated in CSV format by the ABAP job in the SAP system. So if you view the format as excel on SAP side, Then when downloaded to CPS, the CSV default format property is used to determine how to open the file. So can you please check the output file of the ABAP job in

the SAP system - Does the output file show in text format when you check the output file in SAP directly?

Also Can you please check if you have created the Registry key /configuration/mail/AutoExtension=false?

See the following information from the CPS admin guide:

**************************************

Automatic Extensions

SAP CPS appends extensions automatically to text files and HTML files, which do not already have a .txt or .html extension.

You can disable this by specifying one of the following:

1. @autoextension=false - in the comment of the format

2. Registry key /configuration/mail/AutoExtension/<Format_Partition>/<Format_Name>=false
3. Registry key /configuration/mail/AutoExtension=false

Note that the settings are parsed in this order, the first setting found is used. If none are found, the default is true.

*************************************

Regards

Adrienne