Excel Package

Stable Version 1.9.0 (O10)
Also available for 9
Published on 02 August 2018 by 
Created on 03 September 2015
Details
Create advanced Excel 2007/2010 spreadsheets on the server using EPPlus .net library. More information about the library in http://epplus.codeplex.com and https://github.com/JanKallman/EPPlus
Read More
  • Create advanced Excel 2007/2010 spreadsheets on the server using EPPlus .net library.

More information about the library in https://epplus.codeplex.com and https://github.com/JanKallman/EPPlus


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.

What’s new (1.9.0)

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
Reviews (0)
Category
Reporting
Tags
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Sachin Waghmare who created this component.
Dependencies
Excel Package has no dependencies.
Requirements
Platform:
10.0.0.402
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads