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: https://goo.gl/axI0qO
(Fork me on GitHub if you want to contribute)