topic Conversion of Script data to Excel File in Application Development and Automation Discussions

Conversion of Script data to Excel File

Former Member — Mon, 27 Dec 2010 06:22:40 GMT

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.

Re: Conversion of Script data to Excel File

Former Member — Mon, 27 Dec 2010 06:27:31 GMT

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

Re: Conversion of Script data to Excel File

Former Member — Mon, 27 Dec 2010 11:50:24 GMT

*Convert data into OTF

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

Re: Conversion of Script data to Excel File

Former Member — Mon, 27 Dec 2010 16:05:36 GMT

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