Give us feedback
Service icon

Advanced Excel

Stable version 2.2.3 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 3 Mar (3 weeks ago) by 
 (80 ratings)

Advanced Excel

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:

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.3)
  • Added dropdown support from component.
  • Changed CellFormat_ApplyToRange to match expected behavior described here.
  • Created a demo app with some samples (to add more in the future).
  • EPPlus compiled to custom version
    • Custom version based on, targeted to TargetFrameworkVersion v4.8
    • Upgraded FakeItEasy and Castle.Core
    • Fix calculations on .NET Framework (at Compile() function)
    • removed obsolete settings.ProhibitDtd, use DtdProcessing instead
    • some code cleans
    • updated some sample tests
License (2.2.3)
Reviews (8)
30 Jan
in version 2.2.2
This is an amazing component
• Very well documented
• Easy to set and understand

In my opinion, if the grid borderline, as mentioned in this forum question, were to be implemented, it would become even more complete.

in version 2.2.2
Fantastically useful and works perfectly for what I require.
in version 2.2.2
Good documentation, but demo examples are lacking - so we see why so many people post similar difficulties on the forum. I'm still breaking my head to put together a single file composed of several worksheets.