topic Create Excel with Multiple Sheets in Background in Application Development and Automation Discussions

Create Excel with Multiple Sheets in Background

surajarafath — Thu, 15 Mar 2012 01:45:21 GMT

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.

Re: Create Excel with Multiple Sheets in Background

Former Member — Thu, 15 Mar 2012 03:38:07 GMT

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

Specifically, PI: SpreadSheetML

Regards

Raj

Re: Create Excel with Multiple Sheets in Background

surajarafath — Thu, 15 Mar 2012 03:42:48 GMT

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

Re: Create Excel with Multiple Sheets in Background

Former Member — Thu, 15 Mar 2012 05:42:14 GMT

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

Re: Create Excel with Multiple Sheets in Background

UweFetzer_se38 — Thu, 15 Mar 2012 14:55:44 GMT

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

Best regards
Uwe