Repository navigation
Home
This wiki has moved. The EPPlus documentation is now at https://epplussoftware.com/docs/. This page is no longer updated; please use the new documentation and update your bookmarks.
The EPPlus documentation has moved to the EPPlus guides, where it is updated and extended as we improve the docs and add new functionality.
A good way to learn how to use this library is to clone one of the sample projects and explore the code. The sample projects for version 7 is available for C# or VB.NET.
For source code docs, see the API reference. We have separate docs for each supported minor version.
We have created a sample app to demonstrate usage of EPPlus in ASP.NET web applications. You can browse through these samples via this web app and/or clone the Github repository to explore the code.
See this page on how to get started with EPPlus. If you have a problem or a question, try the FAQ.
Here is a link to our roadmap.
EPPlus Software AB - https://epplussoftware.com
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Breaking Changes in EPPlus 8
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Hyperlinks
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- The ExcelRange.Text property
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles
-
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