Stable version 2.3.2 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded

on 13 Jun (11 hours 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.3.2)

Fixes

Workbook_Open — file branch left junk files and locked them.
File.Open(path, FileMode.OpenOrCreate) silently created a 0-byte file on a typo'd path (then EPPlus failed with a cryptic "central directory not found"), and the FileStream was never disposed, so the file stayed locked by the app-pool process until GC.
Now uses FileMode.Open / FileAccess.Read / FileShare.Read and disposes the stream via using.
ConditionalFormatting_DeleteRule deleted the wrong rule.
The guard requires index >= 1, but ExcelConditionalFormattingCollection.RemoveAt(...) is a standard 0-based collection. So the first rule could never be deleted (it would remove rule 2), and every other index was off by one.
Cell_WriteImageByIndex / Cell_WriteImageByName placed the image one cell down-right.
EPPlus's ExcelPicture.SetPosition(row, …, col, …) takes a 0-based anchor. The wrapper passed the OutSystems 1-based row/column raw, so writing to A4 actually landed at B5. Image_Insert already converted correctly (range.Start.Row - 1); this brings the two image actions in line.
Minor cleanup: stray double semicolon in Column_Hide_Show and a dead STDataSeriesStructure curr_series local in Chart_Create.