adding logo to excel file in application server

[Former Member]

hi

i can generate a excel file on application server.is there any way to add a logo to excel file that is placed on application server?

[former_member209120]

Hi  Moorthy,

Use this FM MS_EXCEL_OLE_STANDARD_DAT'

see this link http://wiki.sdn.sap.com/wiki/display/Community/Insert+Picture+Image+in+Excel+using+OLE+Automation

http://wiki.sdn.sap.com/wiki/display/ABAP/how+to+display+internal+table+data+in+excel+with+picture+u...

[Former Member]

can u gv me a simple example passing logo to this FM?i am not able to progress on this

[J_OWENS]

Hi,

I know this thread is posted in 2013, but this is the post which came while searching "Add images in application server to excel", So I think it would be helpful for those who try to add image to excel from application server.

Download existing Bitmap logo in SAP to your presentation server. - Code Gallery - SCN Wiki

Use the FM SAPSCRIPT_GET_GRAPHIC_BDS to get the image from application server (uploaded via se78)

Use the FM SAPSCRIPT_CONVERT_BITMAP to convert the image to bitmap.

Use the FM SCMS_BINARY_TO_XSTRING to convert to xstring

Then use abap2xlsx method SET_MEDIA of the class ZCL_EXCEL_DRAWING to add the image to excel.

Regards

Jesse Owens K

[_IvanFemia_]

Install abap2xlsx and check demo zdemo_excel16

You can add images for different sources

Ivan