excel-epp-utils
Web icon

JSON to Excel Formatted (EPP Utils)

Stable version 1.0.2 (Compatible with OutSystems 11)
Other versions available for 10
Uploaded on 12 March 2021 by 
0.0
 (0 ratings)
excel-epp-utils

JSON to Excel Formatted (EPP Utils)

Details
Library to Provide Excel Functions Open to the Community. Important: Now the only available function is to convert a JSON List to Excel, including a nice header and using auto filters. IMPORTANT: This component converts a JSON list to an Excel. It means that Record Lists from OutSystems (as output of Aggregates or Advanced SQLs need to be assigned to a regular list before serializing them into JSON).
Read more

Library to Provide Excel Functions Open to the Community.

Available function(s) :

ExcelEPPUtils_JSONtoExcel 
INPUT "JSON": Text (Provide a JSON List. Example: [{Name:"A"},{Name:"B"}] )
INPUT "SheetName": Text (Optional Sheet Name)
OUTPUT "Excel": Binary Data (Excel Generated from the JSON List) 








Release notes (1.0.2)

Improvements:

- Enabled the WrapText to all cells;

- Added support to customise the head line color.


Bug fixes:

- Fixed the Newtonsoft.Json.dll DLL error.

Reviews (0)