2018-04-09
1.2.6
Hanno
9.0.0.2
All
.NET
Reporting
[Overview]
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.
[Detail]
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; http://epplus.codeplex.com/
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.