How to export an ALV to Excel with its Header and Logo?

[Former Member]

Hi guys,

I need to download to excel an ALV to excel. I already know how to download the ALV part, with its propertys, fonts, colors, etc. But I don't have a clue about how to download the header and the logo.

Any suggestion?.

Regards,

Eric

[narin_nandivada3]

Hi Eric,

Please check this link for sample code regarding LOGO to Excel

For Header to Excel check this link

Hope this would help you.

Good luck

Narin

[Former Member]

Hi Narin,

I'm going to try that, if it works I'll give you the whole ten points.

Regards,

Eric

[narin_nandivada3]

Hi,

Hope my help would solve your issue..

Good luck

Narin

[Former Member]

Hi Narin,

Yesterday we solved the problem, the post that you provide us gave us an idea. we create a macro in Excel and used it as a guide to identify the objects that we needed to include in the ABAP code.

get property of excel_object 'ACTIVESHEET' = activesheet.

get property of activesheet 'PICTURES' = pictures.

call method of pictures 'INSERT'

exporting #1 = 'C:\Program Files\Microsoft Office\MEDIA\CAGCAT10\j0090070.wmf'.

Regards,

Eric

[narin_nandivada3]

Hi Eric,

Ok fine.

Good luck

Narin