Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Send Excel from ABAP with formating fields

Go to solution
Former Member

‎06-01-2011 4:50 PM

0 Kudos

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

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎06-02-2011 8:00 AM

0 Kudos

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

3 REPLIES 3

Go to solution
Former Member

‎06-01-2011 7:52 PM

0 Kudos

Try building Excel Sheet using transformations...

Go to solution
Former Member

‎06-02-2011 8:00 AM

0 Kudos

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

Go to solution
_IvanFemia_
Active Contributor

‎06-02-2011 6:13 PM

0 Kudos

Hi,

try to read these blogs

[abap2xlsx - Generate your professional Excel spreadsheet from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20046] [original link is broken] [original link is broken] [original link is broken];

[xlsx2abap - Read and edit your Excel files from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20791] [original link is broken] [original link is broken] [original link is broken];

[abap2xlsx - I'm no longer a baby, I grow up and now I'm a fully featured tool|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22285] [original link is broken] [original link is broken] [original link is broken];

[abap2xlsx team has a present for you...|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24636] [original link is broken] [original link is broken] [original link is broken];

Code of this SCN Community project is shared on [Code Exchange|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

Regards

Ivan