Advanced Excel

Stable Version 2.1.23 (O11)
Also available for 10, 9.1, 9, 6
Published on 27 August 2019 by 
Created on 13 May 2013
Available in OutSystems versions:
OutSystems 11

Version 2.1.24

Under Development
Application Package
Published on 16 Mar (3 weeks ago) by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new

Removed NuGet packages and referenced physical DLLs.

Version 2.1.23

Stable
Current
Application Package
Published on 27 August 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Added functionality to create a new workbook with multiple sheets
    • Specify the number of sheets, with a name for the first sheet, or
    • Specify a list of sheet names
  • Updated the Demo App

Version 2.1.22

Stable
Application Package
Published on 27 August 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Added functionality to protect your entire workbook with a password
  • Fixed a bug in  Workbook_Calculate
  • Updated Demo App

Version 2.1.21

Stable
Application Package
Published on 23 August 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Refactored Worksheet_Protect to achieve finer-grained control than just protecting the entire sheet with a password.
    The following properties can now be set individually when protecting a worksheet:
    • AllowAutoFilter
    • AllowDeleteColumns
    • AllowDeleteRows
    • AllowEditObject
    • AllowEditScenarios
    • AllowFormatCells
    • AllowFormatColumns
    • AllowFormatRows
    • AllowInsertColumns
    • AllowInsertHyperlinks
    • AllowInsertRows
    • AllowPivotTables
    • AllowSelectLockedCells
    • AllowSelectUnlockedCells
    • AllowSort
  • Updated the demo app Worksheet protect sample

Version 2.1.20

Stable
Application Package
Published on 22 August 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Added FontColor to CellFormat structure to allow setting the font color when using Cell_Write, Cell_WriteRange or CellFormat_ApplyToRange
  • Updated Demo application references and sample for Cell_Write

Version 2.1.19

Stable
Application Package
Published on 13 August 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Insert image - parameterised the top and left margin settings
  • Updated demo app references

Version 2.1.18

Stable
Application Package
Published on 05 August 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Added several properties to set for Cell formatting:
    • HorizontalAlignment
    • VerticalAlignment
    • WrapText
    • TextRotation
    • ShrinkToFit
    • ReadingOrder
    • QuotePrefix
    • Locked
    • Indent
    • Hidden
  • Update Demo App references

Version 2.1.17

Stable
Application Package
Published on 02 August 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Fixed a bug where the NumberFormat defined in a template would get reset if no number format was specified for the WriteByIndex or WriteRange actions
  • Updated Demo App

Version 2.1.16

Stable
Application Package
Published on 18 July 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Fixed adding an image to a worksheet
  • Updated the demo app

Version 2.1.15

Stable
Application Package
Published on 16 July 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Fixed a bug when writing to a cell with type "formula"
  • Updated the  Demo app

Version 2.1.14

Stable
Application Package
Published on 12 July 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Updated Demo app
  • Added ability to add AutoFilter to a range in a worksheet - Worksheet_AddAutoFilter
    • A range can be specified, or leave blank to use the dimensions of the worksheet

Version 2.1.13

Stable
Application Package
Published on 07 July 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new

Added the following Conditional Formatting rule types:

  • AboveAverage
  • AboveOrEqualAverage
  • BelowAverage
  • BelowOrEqualAverage
  • AboveStdDev
  • BelowStdDev
  • Bottom
  • BottomPercent
  • Top
  • TopPercent
  • Last7Days
  • LastMonth
  • LastWeek
  • NextMonth
  • NextWeek
  • ThisMonth
  • ThisWeek
  • Today
  • Tomorrow
  • Yesterday

Version 2.1.12

Stable
Application Package
Published on 01 July 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new

Added:

  1. Worksheet_AutofitColumns - Auto fit all columns in a worksheet
  2. Image_Insert - Insert an image into a worksheet (Work in progress)

Version 2.1.11

Stable
Application Package
Published on 26 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Refactored mandatory parameters to ease development.
  • Added error checking to enforce parameter requirements.
  • Added Conditional Formatting Rule Delete actions

Version 2.1.10

Stable
Application Package
Published on 23 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Added the following actions:
    • Row_Delete
    • Column_Insert
    • Column_Delete
    • Comment_Add
    • Comment_Delete
  • Refreshed references and added samples to the Demo App


Version 2.1.9

Stable
Application Package
Published on 22 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Added Cell_UnMerge action to unmerge a range of cells
  • Updated demo application with sample of unmerge

Version 2.1.8

Stable
Application Package
Published on 22 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Renamed FindCellsByValue to Cells_FindByValue
  • Added the Cell_Merge action to merge a range of cells
  • Updated the demo application
  • The demo application is now also contained in its own .oap file as per forge requirements

Version 2.1.7

Stable
Application Package
Published on 19 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • The Extension is now contained in a .oap file (application) so it no longer hides in Independent Modules
  • Renamed some actions by removing the Worksheet_ prefix where actions are not applicable to the worksheet object. 
  • Added functionality to set Conditional Formatting for an Address. Currently supporting the following rule types (others will be added over time):
    • LessThan
    • LessThanOrEqual
    • GreaterThan
    • GreaterThanOrEqual
  • Added an action that allows you to retrieve all the Conditional Formatting rules defined for a worksheet.

Version 2.1.6

Stable
Module
Published on 18 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Cell_Write allows "formula' type to write formulas to cells
  • Made the parameters of CellFormat structure non-mandatory

Version 2.1.5

Stable
Module
Published on 11 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Fixed a bug where a hidden column wouldn't show when hidden is set to false.
  • Refreshed demo application references.

Version 2.1.4

Stable
Module
Published on 11 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Updated action comments
  • Added actions:
    • Worksheet_Hide_Show - Hide / Show a worksheet
    • Row_Hide_Show - Hides / Shows Row passed by index
    • Worksheet_Calculate - Calculate all formulae on the provided worksheet.
    • Workbook_Calculate - Calculate all formulae for the entire workbook provided.
  • Updated demo application

Version 2.1.3

Stable
Module
Published on 08 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Minor bug fixes
  • Added Demo project

Version 2.1.2

Stable
Module
Published on 03 June 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new
  • Consolidated the various Cell_Write and Cell_WriteRange actions
    • reduced the number of actions by consolidating name and index actions
    • reduced further by consolidating WithFormat actions
  • Consolidated Worksheet_Select by index and name actions
  • Consolidated Worksheet_Delete by index and name actions
  • Consolidated Workbook_Open and Workbook_Open_Binary_Data actions
  • Attempted to update code comments and summaries for completeness
  • Added NumberFormat as an option in CellFormat
  • Added action to apply CellFormat to a range (a range can be one cell)
  • Removed AddOsDbSheet - it was a duplicate of Cell_WriteRange in a sense but with some bugs, although it allowed for headers in the export  - fixed up Cell_WriteRange to include/exclude headers (Beta testing)
  • Added Workbook_ChangeSheetIndex - Change the index of a worksheet in the document
  • Worksheet_FindCellsByValue - Find all cells that contain the specified value in the given worksheet
  • Added Worksheet_InsertRow - Inserts a new row into the spreadsheet.  Existing rows below the position are shifted down.  All formulas are updated to take account of the new row.
  • Modified Cell_Read to work by index or cell name

Version 2.1.1

Stable
Module
Published on 03 June 2019 by Joao Duro
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new

Added option to BorderStyle in CellFormat attribute.

Version 2.1.0

Stable
Module
Published on 22 May 2019 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
What's new

Fixed a bug in Cell_WriteByName

Version 2.0

Stable
Module
Published on 08 October 2018 by Hanno
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
All
What's new
  1. Renamed the extension to Advanced_Excel.xif
  2. Compiled for platform version 11
OutSystems 10

Version 1.2.8

Stable
Module
Published on 22 June 2018 by Afonso Aguas
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new

Added the Chart_Create action which allows for creation of charts in a specific worksheet. 

Define the ranges of cells from which you want to feed your series into the chart and choose from a number of types by passing in the name of the type.

Check out an example here:

https://www.outsystems.com/forums/discussion/36870/advanced-excel-chart-creation-example/

Version 1.2.7

Stable
Module
Published on 15 June 2018 by René Cornet
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new



A new action has been added to the "Advanced Excel" extension called “Workbook_AddOsDbSheet”.

This action will need a few input parameters, like the WorkbookInObj, the WorksheetName, the OsDbDataSet, the RowStart, the ColumStart and IncludingHeader.

When this action is used for the first time in a row, the WorkbookInObj  should be nullObject().

In that case the action will automatically open a workbook object, which reference will be returned via WorkbookOutObj afterwards.


The next time the action is used the WorkbookInObj will be populated with the previous WorkbookOutObj reference. The use of the other fields is clear, I guess.


Version 1.2.6

Stable
Module
Published on 09 April 2018 by Hanno
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new
  1. Specify the first sheet name when creating a new Excel document
  2. Adding new sheets by name
  3. Delete sheets by index/name

Version 1.2.5

Stable
Module
Published on 29 March 2018 by Hanno
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new

Added Dimension property to expose the number of rows and columns of the worksheet. There is also a string property "address" that returns the cell range of the worksheet.

If there is no data in the sheet, the rows and columns will return 0, and the address property will be undefined.

Version 1.2.4

Stable
Module
Published on 18 March 2018 by Hanno
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET

Version 1.2.3

Stable
Module
Published on 29 November 2017 by Hanno
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new
  • Workbook_GetProperties
    • Returns a list of the Worksheets contained in the Workbook
  • Worksheet_GetProperties
    • Returns the following properties of Worksheet:
      • Name
      • Index
      • Tab Color
        • A (Alpha)
        • B (Blue)
        • R (Red)
        • G (Green)
        • Name
        • IsSystemColor
        • IsKnownColor
        • IsNamedColor

Version 1.2.2

Under Development
Module
Published on 27 November 2017 by Hanno
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new

Added a function Worksheet_GetName that returns, as text, the name of the provided worksheet.

Version 1.2.1

Stable
Module
Published on 15 November 2017 by Hanno
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new

Fixed a bug in Cell_WriteByIndex function

Version 1.2.0

Stable
Module
Published on 24 July 2017 by Hanno
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
What's new
  • Upgrade to platform 10
  • Updated EPPlus reference to version 4.1
OutSystems 9.1

Version 1.1.1

Stable
Module
Published on 30 November 2018 by Micael Ramos
Requirements
Platform:
9.1.0.6
Database:
All
Stack:
All
What's new
  • Fixed a bug in Cell_WriteByIndex function;
  • Added function Worksheet_GetName that returns, as text, the name of the worksheet provided;
  • Added function Worksheet_DeleteByIndex to delete sheets by index;
  • Added function Worksheet_DeleteByName to delete sheets by name;
  • Added function WorkBook_AddSheet to add new sheets by name;
  • Added function Cell_MergeRange to merge multiple cells.
OutSystems 9

Version 1.1.0

Stable
Module
Published on 05 November 2016 by João Rosado
Requirements
Platform:
9.0.0.1
Database:
All
Stack:
.NET
What's new

Upgrade to version 9

OutSystems 6

Version 1.0.1

Under Development
Module
Published on 13 May 2013 by Guilherme Pereira
Requirements
Platform:
6.0.0.0
Database:
All
Stack:
.NET
What's new
Added Features
- Added support for cell formatting
  - Background-Color
  - Font
  - Font-Size
  - Bold
  - Auto Adjust

BugFixes
...

Version 1.0.0

Stable
Module
Published on 06 October 2015 by Carlos Freitas
Requirements
Platform:
6.0.0.0
Database:
All
Stack:
.NET