A Python automation script that combines multiple Excel files, generates a summary report, and can automatically send it via email. Ideal for streamlining business reporting workflows and demonstrating practical automation skills.
- Merge data from multiple Excel files into a single report
- Generate summarized insights and structured output
- Apply formatting to create clean, professional Excel reports
- Optional email automation for instant delivery
- Reduces manual effort and speeds up reporting workflows
- Demonstrates strong automation skills
- Shows understanding of Python + office workflows
- Practical tool for analyst, admin, and operations roles
- Highlights ability to improve efficiency in everyday business tasks
from excel_report_automation import combine_excel, send_email
# Combine multiple Excel files into a summary report
combine_excel(input_folder="monthly_reports/", output_file="summary_report.xlsx")
# Send report via email
send_email("summary_report.xlsx", recipients=["manager@example.com"])
#sample output
Processing 5 Excel files...
Merged data successfully into 'summary_report.xlsx'
Email sent to manager@example.com
Report generation completed!
## 📂 Output File
- **https://1drv.ms/x/c/0667eb20028f8fa8/IQCbufVTJBEbR408r8vU51I0AWjvE1qCY9Pd-w7IhKuAZqI?e=tDDoMV** → This is the **generated summary report** from the script.
It combines multiple Excel files and demonstrates how the automation works.
Recruiters can open this file directly to see the final result without running the code.