Send a complex Excel by Email

[Former Member]

    Hello,

¿Is it possible to attach and send by Email an Excel with ActiveX components and other complex formats?

Im not creating de Excel, simply getting it from de local pc and send it with an ABAP program.

thanks!

[Clemenss]

Hi Fernando,

yes, why not.

An excel file is saved as a binary file - regardless of complexity. You can use cl_gui_frontend_services= gui_upload to get the file into memory. Then use CL_BCS to create email with attachment.

OK, the receiver must have excel and active x installed to make use of it.

See sample code here or in BCS* reports.

Regards

Clemens

[Former Member]

Hi Clemens,

now I have the following problem and I hope you can help me:

I have to :

1) download an Excel template from AL11 to the PC.

2) open the document and write data on it.

3) close the document.

4) upload the document to SAP.

5) send it by mail.

my problem is 2): I have to open it as invisible and write it.

¿do you know how can I do it?

gracias!

[Former Member]

The whole point of going to the PC is to make the file visible to the user.  If you don't want the user to see it, bring it into SAP using one of the EXCEL to internal table functions, modify the data, send it via BCS method calls (see programs named by BCS*).  What's the point in downloading and uploading in this case?

[Former Member]

I have to work with an Excel allocated in AL11... somehow i have to edit it and send it by mail...

this excel has images and and formated cells, and many sheets (I need to edit sheet1)..

i'am downloading the file to be able to work with it..