Skip to Content
0

Background images in Excel using ABAP2XLSX

May 10 at 07:52 AM

61

avatar image

Hello,

I would like to add company logo as Background Image for few cells in Excel using ABAP2XLSX. I have added as an image but my client doesn't want to have Logo as an Object. They wanted to have as Watermark. Please let me know how Can I achieve this? I don't find any methods relating to this.


Your suggestions are much appreciated.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Iftah Peretz
May 10 at 03:40 PM
2

Hey,

Here is an outline to what you should do:

This is not straight forward and the full solution is beyond this scope.

I recommend blogging about the solution once you get it, so that the rest of us could use it.

Show 2 Share
10 |10000 characters needed characters left characters exceeded
I would make a variation, which I think is simpler, or am I wrong?
  • Build a template of an empty Excel with a watermark logo that you can access to via ABAP.
  • Store the template in the application server, load it using the ABAP2XLSX framework.
  • And modify it using the ABAP2XLSX framework.

1

Hi Sandra,

Thank you so much for your suggestion, when I tried to create the template as you suggested, I'm getting the new pane to the right side and it comes whenever i open the file. Can you please help me how to remove this block and to have only the left pane for my template.

Thanks,

Saleem.

watermark-2.jpg (64.0 kB)
0