JSON to Excel Formatted (EPP Utils)

Stable Version 1.0.2 (Compatible with OutSystems 11)
Other versions available for 10
Published on 12 Mar by 
0.0
 (0 ratings)

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) 








What’s new (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)