Skip to content
EPPlus Documentation
Roadmap
Search
EPPlusSoftware/EPPlus
Guides
API Reference
Pricing
Company
EPPlus Documentation
EPPlusSoftware/EPPlus
Introduction
Getting Started
Getting Started
The Sample Project
EPPlus and Docker
EPPlus and Blazor
EPPlus and Linux
Configuration
Versions
Versions
Releases/versioning
Breaking Changes in EPPlus 5
Breaking Changes in EPPlus 6
Breaking Changes in EPPlus 7
Breaking Changes in EPPlus 8
Worksheet & Ranges
Worksheet & Ranges
Addressing a worksheet
Dimension/Used range
Copying ranges/sheets
Insert/Delete
Filling ranges
Sorting ranges
Taking and skipping columns/rows
Data validation
Data validation
Data validation Examples
Data validation Properties
Data validation exceptions
Data Validation and ExcelFormula
Comments
Comments
Comments/Notes
Threaded Comments
Freeze and Split Panes
Header and Footer
Hyperlinks
Autofit columns
Grouping and Ungrouping Rows and Columns
Styling
Styling
Formatting and styling
The ExcelRange.Text property
Conditional formatting
Conditional formatting
Color Scale example
Icon Set example
Custom Iconsets Example
Databar Example
Advanced Color Options Example
Priority Example
Order In the worksheet on Load
Using Themes
Working with custom named table- or slicer- styles
Import/Export data
Import/Export data
Import
Import
LoadFromText
LoadFromText (fixed-width text files)
LoadFromDataReader
LoadFromDataTable
LoadFromCollection
LoadFromCollection (attributes)
LoadFromDictionaries
LoadFromArrays
Export
Export
ToText
ToText (Fixed-width text files)
SaveToText
ToDataTable
ToCollection
ToJson
External connections & query tables
Output formats
Output formats
PDF
PDF
Saving to PDF
Page setup
HTML & CSS
HTML & CSS
Settings
Data attributes
Accessibility
Fonts
Fonts
Configure fonts
Font fallbacks
Formulas and filters
Formulas and filters
Formula Calculation
Formula Calculation
Security considerations
Circular references
Referencing tables in formulas
Supported Functions
Dynamic array formulas
Legacy array formulas
Lambda functions
Regression analysis functions
Custom functions for calculations
Function prefixes
Precision as Displayed
Cancelling a calculation
Trim reference operator
Working with filters
Working with slicers
Working with External Workbooks
Charts & Drawing objects
Charts & Drawing objects
Shapes
Pictures
In-cell pictures
Charts
Charts
Styling Charts
Using chart templates
Supported Charts
Chart samples
Form Controls
OLE Objects
Sparklines
Copy Drawings
Tables & Pivot Tables
Tables & Pivot Tables
Tables
Tables
Table filters and slicers
Built in Table styles
Custom Table Styles
Sorting tables
Working with DataRows
Pivot tables and pivot charts
Pivot tables and pivot charts
Filters and slicers
Styling via pivot areas
Custom pivot table styles
Sorting
Expanding and collapsing Pivot Table items
Using the Data-field - ShowDataAs property
Calculating Pivot tables
VBA & Protection
VBA & Protection
Encrypt and Protect your workbook
VBA
Digital Signatures
Digital Signatures
Signature lines and stamps
Working with Sensibility Labels
About EPPlus
About EPPlus
Security
Roadmap
Roadmap
On this page
Future roadmap
History
Branching strategy and CI
Using our develop nuget feed
License FAQ
On this page
Future roadmap
History
Roadmap
Future roadmap
¶
See the
EPPlus Epics
project.
History
¶
See our
change log