Skip to Content

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

Send Excel from ABAP with formating fields

Hey guys,

i would like to send an excel as an attachement in an email. OK, i found the report BCS_EXAMPLE_7 which is quiet easy to understand. But now i want to insert some text format in this excel e.g. bold text and so on like you can do in OLE2. How can i achieve this? Any ideas?

My first ide was to create the excel file via OLE2 but how can i convert this object to an string which i can send as an email?

thx and regards,

Wei-Ming

Former Member
Former Member replied

Hi Wei-Ming,

You could format an excel sheet using XML transformations as the previous poster has suggested, there is an easy to understand blog from Naimesh on the same, check the below link.

/people/naimesh.patel/blog/2009/02/10/abap-and-excel--create-formatted-excel-using-xml

My first ide was to create the excel file via OLE2 but how can i convert this object to an string which i can send as an email?

But for some reason if you favor OLE, then you could do your formatting using OLE and then use GUI_UPLOAD to load the same file into an ITAB, and then send it as an attachment.

Regards,

Chen

Edited by: Chen K V on Jun 2, 2011 12:30 PM

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question