Q
Problem solve Get help with specific problems with your technologies, process and projects.

OLE functionality for populating Excel files

Need a manual/reference of all functionalities for OLE? This reader was using ABAP to populate Excel files, and now is asking SAP development expert Matt Billingham for help.

I am using OLE to populate an Excel file using ABAP code. I want to know where to find a manual/reference of all functionalities for OLE.

For example:

SET PROPERTY OF CELL 'VALUE' = USERS-NAME1 NO FLUSH.

Where can I find a complete list of all properties that I can set to a cell?

I want to do something like this:

SET PROPERTY OF CELL 'VALUEFORMAT' = 'Date'.

or

SET PROPERTY OF CELL 'TextColor' = 'white'

Can you provide some advice?

Use the VBA help for Excel. You'll find that OLE programming is much easier if you use the DOI classes introduced in R/3 4.6C, rather than coding directly.

Dig Deeper on SAP ABAP

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchContentManagement

SearchHRSoftware

Close