How to read an Excel file and Use Python and Pandas to Work With Excel | Read Description

Описание: Test Scenario:

ABC Pte. Ltd client is requesting a Document Ageing Report for all sub-companies accounts daily from the team. The team member will log in to the system and download export.xls file and will be creating the Final Report.xlsx excel report.

The operation team requested to automate this excel process since currently it is taking 30 Mins per day. You are free to use any automation tool in this operation but as a company, we highly recommended to do the development using a cost-effective solution such as Excel VBA, Java, or Python, etc.

Below are the additional details information provided by the operation team

1. Downloaded report (export.xls file) column structure will be constant however more records (rows) will be added.
2. Final report summary page cell B2 value date should be today date
3. For every account it should create a new sheet and it need to update the summary page
4. In the Account sheet (i.e. 63010001) an additional column needs to be added (column J) and display the date different (formula already given)
5. A new workbook needs to be created after the automation success

Find Excel file,
https://drive.google.com/file/d/1DIV-...