Working with Microsoft Office files

Every Windows system user has heard of the Microsoft Office package. Microsoft Word or Microsoft Excel formats are the most recognizable and characteristic extensions for Windows operating systems. The Office package is also very well integrated with SAP. We have the possibility to export the result to an Excel spreadsheet in many standard transactions. Exporting to Excel is also part of standard ABAP List Viewer (ALV) functionality. In this section, we dive deeper into SAP and Microsoft integration. Reading, writing, and editing examples will be covered. 

Reading data from Microsoft Excel

Let's assume some external system created a report in Excel format. We...