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