Excel EPP Utils (JSON to Excel) - Overview - OutSystems

Community

Login to Download

Traditional Web

0.0

(0 ratings)

0 reviews

41

9

Created on 10 May 2019

Login to Follow

Login to Download

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.

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)

Reviews (0)

Category

Libraries, Components

Tags

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

Excel EPP Utils (JSON to Excel) has no dependencies.

Team

Requirements

Platform:

10.0.0.402

Database:

All

Stack:

.NET

Component Consumers

No consumers yet.

Weekly Downloads

Related Components

A fully responsive and beautiful UI framework that works within the OutSystems Platform. Build amazing looking applications, in a fraction of the time, which work perfectly across devices. Learn how to start using Silk UI and see the examples at silkui.outsystems.com . Obtain assistance on using Silk UI in our forums .

Create amazing applications using this fully integrated UI framework for OutSystems, with dozens of UI patterns ready to use.

Advanced Excel integration with the export/import of Excel files. Enables data formatting, even automatic creation of Excel charts. This enables writing of binary multi-sheet excel-files without the use of an office installation.

More from Rossi

High Quality Image Resize

With this component you can create input/output parameters of generic type "Object", passing any kind of structs of Records or RecordList with the platform function "ToObject(Record/RecordList)" and convert them back from "ObjectToRecordList. This component receive any kind of object struct and read its properties and data. You may use JSON serialization for the same cause, however, with C# reflection this component is very performatic and may no need to perform two operations: Serialize/Deserialize such in JSON.

With this module you could use the logics "ConversaoMoedas", "CotacaoMoeda" and "CotacaoMoedaUltimoValor" to get real time currency exchange rates from the Brazil's Central Bank. Certificate setup in OutSystems required. Please follow internal instructions in the App to setup the certificate. (Module only available in Portuguese)