How SAP ABAP and Microsoft Excel Goes Hand in Hand
Now a days all people are aware of Microsoft products e.g. Excel, Word etc. Its is better to use in daily work. New person in the company is not familiar with new designed SAP Report, newly developed program or any new design screen.
So sometimes, user prefers to display SAP report output in specific MS Excel templates; which contain logos, user specific table formats etc.
MS Excel is excellent way to store data as well as front-end tool. By using SAP ABAP Report , end user will get report in MS Excel with all data, table and also logo etc. After that he will maintain and save data if he want. Main purpose of this scenario for end user can able to add their own information into the SAP Report. By using OLE(Object Link Enabling) we can achieve this functionality. We can show excel direct into foreground. This is a front-end feature. You cannot do this in background. Now its is possible to create SAP ABAP programs providing with MS Excel integration using simple OLE automation technique. For that we need create OLE objects and need to call their methos. There are 5 methods or statement need to use in OLE automation. Also we can also do format of MS Excel report using font, color, date format proprieties method in SAP ABAP report.
Objects: 1. CREATE OBJECT 2. SET PROPERTY 3. GET PROPERTY 4. CALL METHOD 5. FREE OBJECT
Benefit of this scenario is you can embed all static objects or data to be displayed such as logos,headers and table etc in the template, except the area, where the data will be filled at runtime. SAP end user will easily manipulate the report data in their own Excel sheet without training of new SAP developed report or any program using easy interface tool MS Excel or Word. You can show excel output in front-end.
Have a question on this topic ? Please read more here.
Need Help:
In case you need assistance on SAP Support Services, please contact us. Please send us your questions, comments or assistance request and our team would be glad to assist you.
By Dipak Khatavkar (on behalf of SAP Consulting Team)