excel-package
Web icon

Excel Package

Stable version 2.0.0 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded
 on 17 June 2020
 by 
5.0
 (6 ratings)
excel-package

Excel Package

Created on OutSystems 10

Version 1.9.0

Stable
Uploaded on 02 August 2018 by 
Compatible with:
Version 11
11.0.108 to 11.31.0
Version 10
Stack:
.NET
Database:
All
Release notes:

Alined code with Advanced Excel version 1.2.6.

New and changed functions:

Workbook_Create() - Specify the first sheet name when creating a new Excel document

Worksheet_GetName() - returns the name of the worksheet

Worksheet_DeleteByIndex() and Worksheet_DeleteByName() - Delete sheets by index/name

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
  • Dimension
    • Rows
    • Columns
    • Start Address
    • End Address

Version 1.8.0

Stable
Uploaded on 11 May 2018 by 
Compatible with:
Version 11
11.0.108 to 11.31.0
Version 10
Stack:
.NET
Database:
All
Release notes:

Added new functions to write and format cells:

  • Cell_FormatRange() - format a range of cells

  • Cell_WriteColumnRange() - writes a list of values to a range of columns

  • Cell_WriteColumnRangeWithFormat() - writes a list of values to a range of columns with formatting

Created on Older versions

Version 1.2.0

Stable
Uploaded on 31 March 2016 by 
Compatible with:
Version 11
11.0.108 to 11.31.0
Version 10
Version 9
Stack:
.NET
Database:
All
Application Objects:
Excel Package has 0 AOs.

Version 1.1.0

Stable
Uploaded on 23 March 2016 by 
Compatible with:
Version 11
11.0.108 to 11.31.0
Version 10
Version 9
Stack:
.NET
Database:
All
Release notes:
This version fixes the issue regarding the on Cell_WriteByIndex, as described in the link below:
https://www.outsystems.com/forums/discussion/17181/issue-on-cell-writebyindex/

Kudos to Nuno Santos (nuno.santos@outsystems.com)

Application Objects:
Excel Package has 0 AOs.