excel-helper
Service icon

Excel Helper

Stable version 1.0.0 (Compatible with OutSystems 11)
Uploaded
 on 10 Feb
 by 
5.0
 (1 rating)
excel-helper

Excel Helper

Documentation
1.0.0

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.