A python package to automate the extraction of data using SAP Analysis fo Office plugin inside Excel. It opens an Excel workbook and use the API provided by SAP (link) to control the workflow of the data extraction.
This project was possible due to the work of:
All the solutions of them were implemented using VBA and/or VB Script. This project aims to implement the same idea using Python Programming. This language was chosen because it has: 1) A library that can make COM interface with windows applications (such as Excel). That makes easy to convert VBA script to Python. 2) Python has Pandas, witch makes the data transformation workflow a very easy task to be done. 3) Using Pandas you can capture the data refreshed from the Excel workbook and use Pandas Method named to_sql(), to create automatically the SQL insert instruction to ingest data into SQL server.