report_xlsx_helper
This module provides a set of tools to facilitate the creation of excel reports with format xlsx.
Key Features
- reporting: Support for defining XLSX reports in static or dynamic syntax
- reporting: AbstractReportXlsx class with methods for generating Excel reports
- reporting: Support for various cell types including string, number, boolean, and datetime
- reporting: Predefined cell formats for consistent look and feel across reports
- reporting: Easy addition of cell formulas using the _rowcol_to_cell method
- reporting: Support for Excel templates that can be adapted by inherited modules
- reporting: Support for Excel reports with multiple sheets
- reporting: Predefined formats for amounts, percentages, integers, and dates with various alignments
- reporting: Support for bold and conditional formatting in cells
- reporting: Methods for setting column widths and writing worksheet titles
- reporting: Helper methods for writing lines with column specifications
- reporting: Validation of worksheet names to prevent invalid characters
- reporting: Support for headers and footers in worksheets