This Excel Helper component enables dynamic Excel file generation using the ClosedXML.Excel library. It consumes data directly from JSON input, automatically derives column names from the JSON structure, and writes records to the worksheet without requiring predefined schemas.
In addition to JSON-based data, the helper supports inserting custom header and footer rows as structured records, allowing static or formatted content to be placed at the top or bottom of the Excel file. The solution is optimized for performance, uses in-memory processing, and produces a ready-to-download Excel binary output suitable for reporting and data export scenarios.