Automated Excel report

An automated Excel report is a workbook generated by a script: reading the data, calculating with pandas, writing to several sheets, formatting with openpyxl, then saving with a dated name. Rerun on demand or scheduled, it replaces repetitive manual production and always applies the same rules.

Example

The script reads the month's sales and produces rapport_2025-03.xlsx.

Related concepts

The whole glossary