Conversion of Script data to Excel File

[Former Member]

My requirement is to convert the Script data to Excel file and send a mail with attachment of the excel file.

User needs two radio buttons on the selection screen for PDF & Excel file

If user selects Excel file radio button, i need to convert SAP Script data to Excel .

Currently the Script data is converted to PDF and sent as attachment.Please let me know whether it is possible to convert Script data to Excel file.

[Former Member]

YES. Store the script data into a internal table. Use FM GUI_DOWNLOAD to pass the data into excel and then send as email

[Former Member]

*Convert data into OTF

*Then using FM CALL FUNCTION 'CONVERT_OTF' you can convert into PDF ya Excel

[Former Member]

Use 'CONVERT_OTF' fm, in this format type is 'DOC'.After download that file using 'GUI_DOWNLOAD' in this whatever format u want give that in the filemname

for ex: check the below link.In this link some programs are there with output.

http://www.scribd.com/doc/454814/SAPSCRIPT-to-PDF