EPPlus samples

EPPlus samples for .Net Core

The solution can be opened in Visual Studio for Windows or MacOS. On other operating systems please use...

dotnet restore
dotnet run

... to execute the samples.

Table of Contents

1. Workbook Worksheet and Ranges
2. Import and Export
3. Styling
4. Filters and Validations
5. Drawings Charts and Themes
6. Formula Calculation
7. Tables PivotTables and Slicers
8. Encryption Protection and VBA

Workbook Worksheet and Ranges

No	Sample	Description
1.01	Getting started	Basic usage of EPPlus: create a workbook, fill with data and some basic styling
1.02	Read an existing workbook	Read in a workbook
1.03	Using async await	Async Await in Epplus
1.04	Fill copy and sort ranges	Different range operations
1.05	Notes and threaded comments	Handling notes and Comments in Epplus
1.06	Sales report with hyperlinks	Hyperlink and database guide
1.07	Performance write	Loading and writing in a performant way
1.08	Performance read using linq	Using Linq on Cells
1.09	External links	External links to other workbooks
1.10	Ignore errors	How to ignore errors on ranges

---

Import and Export

No	Sample	Description
2.1	Load data from collection	Load data into worksheet from various types of objects. It also demonstrates the Autofit columns feature.
2.2	Export data to collection	Demonstrates Export ranges and tables into an IEnumerable<T> where T is a class type.
2.3	Import export csv files	Async Await in Epplus
2.4	Import export DataTable	Different range operations
2.5	Export to html	Handling notes and Comments in Epplus
2.6	Export to json	Hyperlink and database guide

---

Styling

No	Sample	Description
3.1	Styling basics	Demonstrates how to apply different styling on cells including Fills, Fonts etc.
3.2	Conditional formatting	Demonstrates all conditional formatting and how to apply styling/Formatting.
3.3	Fx report from database	This sample produces a workbook with foreign exchange rates.
3.4	Create a file system report	Demonstrates usage of styling, printer settings, rich text, pie-, doughnut- and bar-charts, freeze panes.

---

Filters and Validations

No	Sample	Description
4.1	Data Validations	Demonstrates how to apply different styling on cells including Fills, Fonts etc.
4.2	Filter	Demonstrates all conditional formatting and how to apply styling/Formatting.

---

Drawings Charts and Themes

No	Sample	Description
5.1	Shapes and images	How to create shapes and images using EPPlus and apply effects
5.2	Open workbook add data and chart	Open an existing workbook with EPPlus, add data and charts
5.3	Charts And themes	Demonstrates how to use various types of charts, chart styling and themes
5.4	Sparklines	demonstrates EPPlus support for Sparklines
5.5	Form controls	demonstrates how to Add form controls, like drop-downs, buttons and radiobuttons to a worksheet and grouping drawings via VBA Macro

---

Formula Calculation

No	Sample	Description
6.1	Formula Calculation	shows formula calculation capabilities of EPPlus
6.2	Dynamic Array Formulas	Example of dynamic array formula calculation

---

Tables Pivot Tables and Slicers

No	Sample	Description
7.1	Tables	Samples of creating and calculating tables in Epplus
7.2	Pivot Tables	Pivot table functionality of EPPlus
7.3	Slicers	Slicers for table and pivot table slicers
7.4	Custom Named Styles	Example for how to create custom slicer styles

---

Encryption Protection and VBA

No	Sample	Description
8.1	Encryption and Protection	Sample of encryption and password protection
8.2	VBA	An implementation of a Battleship game, implemented in Excel/VBA as an example of epplus+VBA interaction

Also see wiki on https://github.com/EPPlusSoftware/EPPlus/wiki for more details

Output files

The samples above produces some workbooks - the name of each workbook indicates which sample that generated it. These workbooks are located in a subdirectory - named "SampleApp" - to the output directory of the sample project.

Feedback and issues in the sample project.

If you have feedback or want to report and issue in the sample project, please use the EPPlus issue tracker