excel-generator

Automating Excel workbook creation is handled by programmatically generating .xlsx files with built-in formatting, formulas, and charts. This module reduces repetitive manual spreadsheet work by supporting openpyxl and xlsxwriter backends to structure data and visual outputs.

Modifying existing .xlsx files is fully supported for round-trip edits, and reading legacy .xls (Excel 97-2003) formats is also available. You can programmatically load these workbooks to update formatting, formulas, or data validation rules.

Generating Excel reports and data-entry templates is best done by programmatically defining data structures and applying data validation rules. This module creates polished workbooks suitable for dashboards and pricing sheets, automating the layout and formula injection.

Both openpyxl and xlsxwriter backends are supported for writing .xlsx files, alongside pandas shortcuts for multi-sheet workbooks. This allows you to choose your preferred library for memory management and chart referencing when creating spreadsheets.

Limitations exist around memory usage, formula handling, and chart references depending on the chosen backend. The module documents these caveats to help you avoid common pitfalls when writing complex formulas or referencing chart data ranges.

Pandas shortcuts are supported for creating multi-sheet Excel workbooks. This allows you to efficiently export multiple dataframes into a single .xlsx file while still applying formatting and generating charts across the different sheets.