Give us feedback
advanced-excel
Service icon

Advanced Excel

Stable version 2.2.13 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 21 Nov (14 days ago) by 
4.7
 (84 ratings)
advanced-excel

Advanced Excel

Details
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.
Read more

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


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.

Release notes (2.2.13)

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

  • Title
  • Subject
  • Author
  • Comments
  • Keywords (ie Tags)
  • LastModifiedBy
  • Category
  • Status
  • Company
  • Manager

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.

License (2.2.13)
Reviews (11)
1 Nov
in version 2.2.12
Really great component, our end users are happy with it, and on top of it, when a bug is found, authors are reactive, really appreciated :)
1 Oct
in version 2.2.5
This one of the best components that can be used to manipulate excel data.
24 Aug
in version 2.2.3
This component is great, I use it on every project. It has a good set of functionality, it is kept up to date and is reliable. I can highly recommend this component to generate, read and/or manipulate Microsoft Excel documents.
Well done!