Output Form Graphic in Excel Output

[Former Member]

Hi all,

I've a client who has decided that, instead of shipping documents displayed via SAPScript or Smartforms, they wish to have the shipping details output to Excel. I'm using the OLE functionality, which is working well. However, they want the corporate logo, which is stored in SAP, to be displayed on the Excel page.

I can go so far, using BDS method cl_ssf_xsf_utilities=>get_bds_graphic_as_bmp and function module DP_CREATE_URL to get the SAP URL for the Image (SAPR3://70A195C3C780ED4B8D8CEC45C4D84CA8). Any ideas on how to get the SAP/Application server image onto the Excel Output? Any help would be greatly appreciated.

Regards,

Stephen

[former_member215917]

Hi Stephan,

You can use xml option to download to excel with OLE. With xml, you can try embedding picture into excel with available tags.

e.g.

<pictures xmlns:ns="http://www.coursesweb.net">

<ns:image>img1.jpg</ns:image>

<image>img2.png</image>

</pictures>

Let me know if this helps.

Gouri.

[Madhurivs23]

Hi Stephen,

Please go through the following link:

http://wiki.sdn.sap.com/wiki/display/Snippets/FormattedExcelasEmailAttachment

you can convert your data into XML and then pass it as excel attachment.

Regards,

Madhuri

[former_member669968]

Hey,

Did you find solution to this? Would you mind sharing the code?

Thanks,

Shruti