Github repo

There is a github repo set up for Advanced Excel and a fork of the EPPlus library so feel free to contribute with pull requests:
1. https://github.com/HannoCoetzee/EPPlus
2. https://github.com/HannoCoetzee/outsystems_advancedexcel

Feature List

• Write of data-sets or single cells;
• Reading of each cell, interpreting different data types;
• Open an existing excel workbook;
• Create new workbooks;
• Manage worksheets;
• Save the workbook to disk, or download;
• Creation of Named Ranges;
• Workbook / Worksheet password protection

Main Benefits

• Enables advanced export of office spreadsheets using a base spreadsheet that can have multiple sheets, branding and several formatting options (done in the excel base file);
• Create named ranges with value to validate data input.

System Requirements and Limitations

• Works with office 2007/2010 format;
• Only a small subset of the library is being used; https://www.epplussoftware.com/

Notice: This component takes advantage of private and undocumented Platform APIs, which can change without notice. As a result, this component may unexpectedly break as the Platform is upgraded. We advise proper testing to ensure that your applications continue to work as expected when upgrading/patching the Platform.