Give us feedback
excel-png
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 
4.7
 (80 ratings)
excel-png

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.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 4.5.3.4.
    • Custom version based on 4.5.3.3, 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.
https://www.outsystems.com/forums/discussion/83656/advanced-excel-how-to-make-grid-borderlines/

Thanks
2022-12-23
in version 2.2.2
Fantastically useful and works perfectly for what I require.
2022-11-29
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.