topic Re: adding logo to excel file in application server in Application Development and Automation Discussions

adding logo to excel file in application server

Former Member — Fri, 16 Aug 2013 06:32:02 GMT

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?

Re: adding logo to excel file in application server

former_member209120 — Fri, 16 Aug 2013 06:46:04 GMT

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+using+OLE

Re: adding logo to excel file in application server

Former Member — Fri, 16 Aug 2013 08:31:42 GMT

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

Re: adding logo to excel file in application server

J_OWENS — Wed, 01 Apr 2015 06:22:15 GMT

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

Re: adding logo to excel file in application server

_IvanFemia_ — Sat, 04 Apr 2015 01:36:09 GMT

Install abap2xlsx and check demo zdemo_excel16

You can add images for different sources

Ivan