Stable version 2.7.2 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded

on 2 Jul (3 days ago)

4.8

(101 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.7.2)

Bug fixes

Worksheet references stay valid after saving. Worksheet references obtained before Workbook_GetBinaryData or Workbook_SaveRightToLeft stopped working after the call — writes through them could be silently lost, and passing one to Workbook_AddSheet could crash. They now keep working.
Hyperlinks are preserved when copying a sheet to another workbook. Workbook_AddSheet / Workbook_AddCopyWorksheet kept the display text but dropped the link.
Cell values read back identically on any server locale. Raw reads from Cell_Read, Cell_ReadByIndex/ByName and Worksheet_ReadRange were formatted with the server's culture — a decimal written as 1.5 could read back as 1,5. Reads with ReadText enabled still return Excel's display text, unchanged.
Worksheet_GetMergedCellRanges (and the workbook variant) no longer list removed merges as garbage entries.

Improvements

ConditionalFormatting_GetAllRules now returns a data-bar rule's colour and show-value settings instead of only the rule type.
Worksheet_AddDropdown gives a clear error when the inline item list exceeds Excel's 255-character limit, instead of producing a dropdown Excel silently drops. Use a cell range (ItemsAddress) for longer lists.

License (2.7.2)

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

Reviews (22)