Send an Internal Table as an excel(in seperate sheets) via email

[Former Member]

Hi all,

How can i send the data in internal table as email in excel form with more than one sheet being used,

example :

1.Date of joining, Period of education, Name

2. Conclusion report having

one field (say No. of students joined)

3. Detailed Report

With a table having five more fileds

I want to send the 3 reports in single excel using 3 sheets in it..

Any pointers would be really helpful..

Thank You.

[Former Member]

Hi Dinesh,

Your requirement can be fulfilled.

1. First step would be to download the internal table into the excel format using the standard FM's.

SAP_CONVERT_TO_XLS_FORMAT.

GUI_DOWNLOAD

WS_EXCEL

ALSM_EXCEL_TO_INTERNAL_TABLE

2. Dealing with multiple worksheets of an excel sheet could be done using the OLE concept. U need to use the OLE classes to make use of the multiple worksheets of the same excel document. You need to map each internal table to a new worksheet in excel.

3. Third step would be to use FM to send the excel sheet to appropriate mailing address.

SO_NEW_DOCUMENT_ATT_SEND_API1

Regards,

Kiran

[former_member181995]

Dinesh,

i found from SDN only.

refer:

you may want to also use search on SDN for more help.

Amit.