Create Excel with Multiple Sheets in Background

[surajarafath]

Hello All,

I have requirement that i need to create an excel sheet with multiple sheets and attach into email. (There should be no Output)

Let say, I have 4 Internal Tables and now i need to create Excel with 4 sheets. In my email attachment i have used STRING_TO_SOLIX method to convert email.

So it would be better for me, if i can do this and convert that excel file into string. I have searched a lot and then i posting, hope some of you will throw some good ideas into it. I dont think OLE will help, because it will be done in foreground i guess.

[Former Member]

Hi

Please refer to the wiki http://wiki.sdn.sap.com/wiki/display/ABAP/Excel+with+SAP+-+An+overview

Specifically, PI: SpreadSheetML

Regards

Raj

[surajarafath]

Thanks Rajesh, I have already gone through it, very clearly. I dont think it will help for me.

[Former Member]

To send XLS attachment to an Email using the XML method
http://wiki.sdn.sap.com/wiki/display/Snippets/Formatted+Excel+as+Email+Attachment

This link may help you.

Reagards,

Gaurav

[UweFetzer_se38]

or try the SAP Code Exchange project "abap2xlsx" https://cw.sdn.sap.com/cw/groups/abap2xlsx

Best regards
Uwe