Background images in Excel using ABAP2XLSX

[former_member281310]

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.

[iftah_peretz]

Hey,

Here is an outline to what you should do:

• Build a template of an empty Excel with a watermark logo that you can access to via ABAP.
• Generate your Excel using the ABAP2XLSX framework.
• Inject the Excel your created into the template with the watermark.

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.

[Sandra_Rossi]

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.

[former_member281310]

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.