Stable version 2.14.4 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded

on 11 Nov (2 days ago)

4.7

(103 ratings)

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.

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

Fixes:

ConditionalFormatting_GetAllRules no longer fails on colour-scale rules in a workbook that was opened from a file, saved or copied. The stop colours are now read correctly. A theme or indexed colour reads as an empty value.
Bold, italic, strikethrough and underline set by Excel on a conditional format are now read as on. This applies to ConditionalFormatting_GetAllRules and to copying a sheet.
Text fields that a returned conditional format doesn't use are now empty instead of null.
Copying a sheet with conditional formats from a file into another workbook no longer makes later saves of that workbook fail.
An alignment or border style number that Excel doesn't have (for example 99) is now rejected with a clear error that names the field and the valid numbers, before anything in the workbook changes. Before, it made the next save fail. This applies to Cell_FormatRange, CellFormat_ApplyToRange and the write actions that take a CellFormat. Negative alignments and a BorderStyle of 0 or less still mean "leave as is".
Conditional formats can again be added to files whose styles use a namespace prefix and don't yet have any conditional format styles.

License (2.14.4)

BSD-3 license (https://opensource.org/licenses/BSD-3-Clause)

Reviews (24)

26 Sep

in version 2.13.1

Solid component, it's my go-to for any Excel import/export. Covers pretty much everything I needed: formatting, multiple sheets, formulas. The number of actions is a bit overwhelming at first and some of them aren't well documented, so I ended up testing to see what each one does. Keep an eye on memory with really big files.