EXCEL - SAP integration ... which way forward?
A customer (having a SAP 4.6D system) would like to have an EXCEL sheet being populated with SAP data with some additional formatting (headers, subheading, totals, colouring cells based on certain values; etc ...) within the EXCEL sheet ...
Out of my head I could think of some possibities here:
- ALV view of table with download (but no extra formatting options here ... )
- ABAP OLE commands (not sure this is still being used)
- EXCEL integration via BDS ( I remember that you can have a both way integration here but how far does it go?)
- RFC communication to for example .NET RFC server via .NET connector ..
Anyone having any experience in this? What are the pro's and cons of any of the possibilies? Anyone any suggestion on what is the best way forward?
My customer is looking for a 'cheap' fast solution and is not willing to spend more then 2-3 days on it ...