Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Mail excel sheet

Hi,

I create an excel sheet using the following code:

CREATE OBJECT excel_app 'EXCEL.APPLICATION' NO FLUSH.

CALL METHOD OF excel_app 'Workbooks' = excel_workbook NO FLUSH.

CALL METHOD OF excel_workbook 'Add' = excel_sheet NO FLUSH.

The parameters excel_app, excel_workbook and excel_sheet are OLE2_OBJECT objects.

Further more addtion calls to fill the sheet are done.

To display the sheet the following code:

SET PROPERTY OF excel_app 'Visible' = 1 no flush.

This is working and on the client the excel sheet is displayed.

The change I need to make is not to display the excel sheet but mail that sheet.

I have searched a lot here on sdn, google etc but found nothing how to do that.

One option would be to save the sheet on a file system and add that as attachment but in my opinion that's not the solution.

What would be an other option?

TIA,

Patrick Willems

Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question