SAP ABAP EXCEL FORMAT REQURIMENT

[Former Member]

Hi All,

     Please help me

     I have a following requirement,

     we are doing attachment of excel file in mail body and sending it in mail.

     i have to send attchment mail everyday, so i want to add excel sheet everytime in mail Excel file.

     for an example,

     Main Excel file contains name : book.xls and it contains sheet1. (for current date)

     now on next date i want to add excel sheet in main Excel file (book.xls) instead of creating new excel file.

     So, everyday sheet1, sheet2,sheet3,...,sheetn will be appened in main excel file book.xls  and  have to keep sheet name as current date name.   

Thank you,

Angit

[arindam_m]

Hi,

Check the wiki below, Should give you a insight into how to get started with it.

http://wiki.sdn.sap.com/wiki/display/Snippets/Multiple+sheet+Excel+Document+from+SAP+using+OLE

Cheers,

Arindam