JSON to Excel Formatted (EPP Utils)

Stable Version 1.0.2 (O11)
Also available for 10
Published on 12 Mar by 
Stable Version 1.0.2 (O11)
Also available for 10
Published on 12 Mar by 
Created on 10 May 2019

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)
Category
Functional libraries & utilities, PDF & file converters
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Rossi who created this component.
Dependencies
JSON to Excel Formatted (EPP Utils) has no dependencies.
Team
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads