topic How to convert SAPScript data to Excel file in Application Development and Automation Discussions

How to convert SAPScript data to Excel file

Former Member — Mon, 25 Oct 2010 12:00:46 GMT

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.

Re: How to convert SAPScript data to Excel file

brad_bohn — Mon, 25 Oct 2010 14:38:52 GMT

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.

Re: How to convert SAPScript data to Excel file

Former Member — Tue, 26 Oct 2010 05:50:08 GMT

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.