topic Send a complex Excel by Email in Application Development and Automation Discussions

Send a complex Excel by Email

Former Member — Fri, 29 Jun 2012 14:33:53 GMT

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!

Re: Send a complex Excel by Email

Clemenss — Fri, 29 Jun 2012 16:09:23 GMT

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

Re: Send a complex Excel by Email

Former Member — Wed, 11 Jul 2012 19:12:32 GMT

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!

Re: Send a complex Excel by Email

Former Member — Wed, 11 Jul 2012 19:56:25 GMT

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?

Re: Send a complex Excel by Email

Former Member — Wed, 11 Jul 2012 20:40:00 GMT

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..