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/EPPlus2. https://github.com/HannoCoetzee/outsystems_advancedexcel
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.
Added 3 new functions to access Microsoft Office properties of an Excel workbook
Workbook_GetProperties, Workbook_SetProperties and Workbook_ClearProperties.
The Microsoft Office properties included are
Consider using Workbook_ClearProperties when exporting a workbook created from a template, to clear the names of any people within the organisation from the workbook to avoid social networking security issues.
Also renamed the existing Workbook_GetProperties to Worksheet_GetPropertiesAll. It retrieves a list of worksheet properties for the workbook rather than the properties of the workbook.