Zerodha Data Automation in Excel

I need an Excel file updated into Zerodha format with earnings reports. The fields include Revenue, Profit/Loss, and EPS. Additionally, I require automation for report generation.

Requirements:
- Update Excel with earnings reports data.
- Format data according to Zerodha requirements.
- Automate report generation in Excel

Ideal skills and experience:
- Proficiency in Excel
- Experience with Zerodha and financial data
- Automation skills, preferably with Excel macros or similar tools

Please provide samples of similar work done.