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.7
 (93 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 (17)
by 
28 May (12 days ago)
in version 2.2.19
Great component! Very helpful! 
by 
26 May (14 days ago)
in version 2.2.19
Very useful component, thanks!
by 
21 May (3 weeks ago)
in version 2.2.19
good component.
Team
Other assets in this category