Table creation in EXCEL - SAP OLE

[former_member622454]

Hi Experts,

I have a requirement to design a table (Item details in invoice) in excel which is generated by SAP. Request you to please let me know how to design table and populate it in excel and also please let me know if it is possible to insert logo in the excel sheet.

Regards,

Sivapriya. N

[Tomas_Buryanek]

Does it have to be via OLE?
If not, then ABAP2XLSX is recommended way. It can create modern XLSX files and can do it in background run (OLE needs access to frontend).
There are many nice DEMO programs in ABAP2XLSX package. Some of them also shows how to add logo to Excel sheet.

[former_member622454]

Installing ABAP2XLSX is not allowed by client so based on my understanding we dont have other option except OLE.

[Sandra_Rossi]

Sivapriya Nandyala Why a client doesn't want to use a "must-have" free product advised by all SAP community, and instead use slow technology, not evolutionary and so on?

[Sandra_Rossi]

OLE allows almost everything in Excel (99,9% of what you can do manually).

There are lots of examples on the web. I advise you to record macros in Excel, it generates VBA code based on your actions, and translate manually the VBA code into ABAP OLE statements, as shown partially in this blog post by ricardo.romeromata.