How to create Worksheet in excel and send Email with attachament

[Former Member]

Hi Gurus,

Have Requerment need write excel in to desktop which could have DIFFERENT number of WORKSEETS in sigle EXCEL and attach this attachment in EMAIL options.please guide me the how to solve prombelm through abap coding.

Regards,

santosh

[Pranay_Panchbha · Accepted solution]

hiiiiiiiiiiiiiiiiiiiiiii

check this link may this sort out ur problem and clear ur query

[http://wiki.sdn.sap.com/wiki/display/Snippets/DownloadDataintoMultipleSheetExcelDocumentwithNonEditableColumns(Passwordprotected)UsingABAP+OLE]

or

[http://wiki.sdn.sap.com/wiki/display/Snippets/UploadingmultiplemultitabExcelsheetsorRangesfromFrontendto+SAP]

or

[http://wiki.sdn.sap.com/wiki/display/Snippets/MultiplesheetExcelDocumentfromSAPusing+OLE?showChildren=false]

Edited by: pranay panchbhai on Mar 20, 2010 5:25 PM