Q

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.
This was first published in June 2005

Dig deeper on SAP ABAP

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close