Application Development Blog Posts
Learn and share on deeper, cross technology development topics such as integration and connectivity, automation, cloud extensibility, developing at scale, and security.
Showing results for 
Search instead for 
Did you mean: 

OLE2Object - ABAP OLE2 Object Utility Class

As we all know, sometimes comprehensive dynamic Excel automation developments can be a little bit complicated with OLE2_OBJECT methods. You have to record a macro and find out what's going on in VBA (Visual Basic for Applications) codes for each specific process, if you don't know it backwards .)

Hence, about a year ago I wrote a simple utility class for mostly needed common processes (e.g. set/get values, formatting options etc.) in Excel automation. You can simply create a new Excel sheet or open an existing one and manipulate it as you want.

You can just copy and paste the code in "Source Code-Based" class builder editor of a global usual ABAP Class.

Source code on GitHub:
(Fork me on GitHub if you want to contribute)

Originally published at – ABAP OLE2 Object Utility Class