SO_NEW_DOCUMENT_ATT_SEND_API1 - Excel download

[vallamuthu_madheswaran2]

Hi Team,

I have used FM SO_NEW_DOCUMENT_ATT_SEND_API1 to send an mail. I have formatted the excel(Header is colored one, Font size is different etc). I need to download the same formated excel in presentation server,

Is there any option in that fm or is there any other way to download the formatted excel to presentation server.

Thanks with Regards,

Vallamuthu M.

[FredericGirod]

Could you clariy your question ?

What is the link between Send and email and Save a file ? it is the same file, yes, but the mail will not do the job for you

[vallamuthu_madheswaran2]

Hi Frederic Girod,

Thanks for your update.

There are 2 radio buttons. one is for, to download the excel another one is to send a mail with excel attachment.

Now the client wants the same formatted excel for download.

Thanks with Regards,

Vallamuthu M.

[FredericGirod]

Yes and ? what is your technical issu ? you probably create a method to build this excel file you just have to upload it

[vallamuthu_madheswaran2]

Hi Frederic Girod,

In excel header needs to be bold, italic and green color background. I have done it in mail option but I am not able to do it in download option. I am looking for sample program or high level guidance.

Thanks with Regards,

Vallamuthu M.

[FredericGirod]

What you need is here :

https://wiki.scn.sap.com/wiki/display/ABAP/abap2xlsx

[Velu]

Hi Vallamuthu,

Kindly refer to the below link which has the answer to achieving the functionality you have mentioned in your question.

Excel_Download_OLE

Thanks

[Sandra_Rossi]

abap2xlsx is better on all aspects (except if using open source software is forbidden by company)

[vallamuthu_madheswaran2]

Hi Gopalakrishnan,

How to save the excel in the given filepath instead of popup the excel?

I have tried to save the excel. But it gives an error

Thanks with Regards,

Vallamuthu M

[Velu]

Could you please share the error you are getting? And the code ?

[Sandra_Rossi]

Any file = sequence of bytes stored in a given folder and under a given name

Email attachment = the same sequence of bytes attached to the email under a given name

Download to laptop = download the same sequence of bytes via method GUI_DOWNLOAD of CL_GUI_FRONTEND_SERVICES.

If you have a problem, please share your code which is concerned, explain the symptoms and how to reproduce (as for any problem).