Excel / ABAP / OLE ! How ?

Former Member · ‎2004 Feb 19

Hello people! I need to create an excel file and populate several sheets! How can I do this in ABAP??? I'm in 4.5B.

Regards,

Fábio Alessandro Comassetto.

Former Member · ‎2004 Feb 20

Although it's not very efficient, I think you might be stuck with using OLE Automation to populate the different sheets of the workbook.

This can only be done in dialog, as it requires the SAPGUI to act as the go-between for the SAP application server and Excel.

Scott

Former Member · ‎2004 Feb 20

Where could I get some documentation about "using OLE with ABAP"???

Thanks,

Fábio.

Former Member · ‎2004 Feb 20

Look at the ABAP documentation for CREATE and then follow-through to the section on CREATE OBJECT in OLE2 Automation.

There are a number of examples too. You might like to start with transaction OLE.

Scott

Peter_Inotai · ‎2004 Feb 20

Check 'Office integration' node in transaction <i>DWDM</i> or the online help:

Incho

Former Member · ‎2004 Feb 24

best way is to use DOI and BDS technology.

look at I_OI_CONTAINER_CONTROL and CL_GUI_CUSTOM_CONTAINER

former_member688119 · ‎2013 Apr 29

This message was moderated.

former_member688119 · ‎2013 Apr 29

Go through Below link definetly help full.