epplus

Topics related to epplus:

Getting started with epplus

EPPlus is a .NET library that reads and writes Excel 2007/2010/2013 files using the Open Office Xml format (xlsx).

EPPlus supports:

Cell Ranges
Cell styling (Border, Color, Fill, Font, Number, Alignments)
Charts
Pictures
Shapes
Comments
Tables
Protection
Encryption
Pivot tables
Data validation
Conditional formatting
VBA
Formula calculation

Formatting values

Saving the Excel document

Styling the Excel document

Filling the document with data

Creating formulas and calculate ranges

Creating charts

Importing data from existing file

Append data to existing document

Tables

Merge Cells

User Input Validation

Columns and Rows

Pivot Table

Rich Text in cells