JSON to Excel Formatted (EPP Utils) - Overview (O11)

Stable version 1.0.2 (Compatible with OutSystems 11)

Other versions available for 10

Uploaded

on 12 March 2021

0.0

(0 ratings)

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).

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)

Team