EPPlus 5

Features and technical overview

Features and technical overview


EPPlus is a .NET Framework/.NET Core library for managing Office Open XML spreadsheets, distributed via Nuget . Version 5 supports .NET Framework from version 3.5 and .NET Core from version 2.0. It is currently a single DLL and has no dependencies to any other library such as Microsoft Excel.

The library is designed with the developer in mind. Our goal has always been that a developer with knowledge of Excel or any other spreadsheet library should easily get up to speed the API. Or - as someone said - intellisense your way to victory!

News in EPPlus 5

Features supported

  • Cell Ranges
  • Cell Styling
    • Number
    • Alignment
    • Font
    • Fill
    • Border
    • Protection
    • Names Styles
  • Formula calculation
  • Import data from files, DataTable's or Collection's (.NET objects)
  • Export data to csv files
  • Supports load and save from/to both files and streams
  • Templates
  • Auto filters/Table Filters
  • Data validation
  • Conditional Formatting
  • Tables
  • Pivot Tables
  • Hyperlinks
  • Comments
  • Shapes
  • Pictures
  • Charts
  • Sparklines
  • Themes
  • Protection
  • Encryption
  • VBA
  • Document/Printer Settings