How to convert SAPScript data to Excel file

[Former Member]

Hi Experts,

Curenntly I am converting SAP Script data to PDF file and send an e-mail with attachment (PDF file).

Same like this, is that possible to covert thda Script data to Excel file to send mail with attachment.???

If, yes please sugget with respective Function Modules.

Thanks In Advance.

Best Regards.

[brad_bohn]

I can't think of a reason why you would go directly from OTF-based tabular data to an Excel attachment. Why don't you use the base internal table data to render the Excel attachment? A little more information about your process would be helpful.

[Former Member]

Hi,

Thanks for response, Here providing more inforamation.

Presently my report displaying Customer information. As per user requirement, coverting the Script data to PDF by using

CALL FUNCTION 'CONVERT_OTF_MEMORY'
          EXPORTING
            format                = 'PDF'
            max_linewidth         = 132
          IMPORTING
            bin_filesize          = doc_size
          TABLES
            lines                 = htline.

Now user want to add two radiobuttons on selection screen for PSF file & Excel file

If user seleacts Excel fiel radio button, then I need to covert the SAP Script data to Excel file lik I have done for PDF.

I'd like to know is that possible covert the Script data to Excel file. If yes, suggest with FMs or process.

Best Regards.