Stable version 2.3.2 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded

on 13 Jun (yesterday)

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.