advanced-excel
Service icon

Advanced Excel

Stable version 2.2.19 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded
 on 09 December 2024
 by 
4.8
 (97 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 (LGPL licence)
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


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.19)

Breaking Changes

  • None


Non-Breaking Changes

  • Added the following actions, courtesy of a pull request by Beatriz
    • Cell_ConvertHexCodeToRGB
    • Cell_GetFillColorByIndex
    • Cell_GetFillColorByName

Note: The last two functions were previously requested here

License (2.2.19)
Reviews (21)
by 
4 Aug (5 days ago)
in version 2.2.19
Nice component, it really helped!
by 
29 Jul (11 days ago)
in version 2.2.19
A very effective solution!
by 
16 Jul (3 weeks ago)
in version 2.2.19
Excellent component for Excel use cases!
Team
Other assets in this category