Recently i was trying to format an excel file from SAP, which i did using OLE. But at the time of doing that, i found that the performance is taking a back seat. I also felt that there might be some better way of doing the integration of MS Office with SAP.
So can anyone suggest how i can achieve that using DOI? Can anyone explain how i can go about learning DOI? If you have any simple example, like how to start an empty excel file and then fill it with data, say from an internal table in one of the sheet; filling the data of another internal table in another sheet but in the same excel file and then format it.
I also heard that it can be achieved using ALV? Any idea?
Any help on this regard is greatly appreciated.
Thanks & Regards