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.

No	Sample	Description
01	Getting started	Basic usage of EPPlus: create a workbook, fill with data and some basic styling
02	Read workbook	Read data from a workbook
03	Async/Await	Using async/await methods for loading and saving data
04	Loading data	Load data into a worksheet from various types of objects and create a table. It also demonstrates the Autofit columns feature.
05	Import and Export csv files and create charts	This sample shows how to load and save CSV files using the LoadFromText and SaveToText methods, how to use tables and how to use charts with more than one charttype and secondary axis.
06	Calculate formulas	How to calculate formulas and add custom/missing functions in a workbook
07	Open workbook and add data/chart	Opens an existing workbook, adds some data and a pie chart.
08	Sales report	Create a report with data from a SQL database.
09	Performance and protection	Loads 65 000 rows, styles them and sets a password.
10	Read data using Linq	This sample shows how to use Linq with the Cells collection to read sample 9.
11	Conditional formatting	Demonstrates conditional formatting.
12	Data validation	How to add various types of data validation to a workbook and read existing validations.
13	Filters	How to apply filters in a worksheet or a table
14	Shapes & Images	Shows how to add shapes and format them in different ways.
15	Chart Styling & Themes	Load a theme and create various charts and style them.
16	Sparklines	Demonstrates sparklines functionality.
17	FX report	Exchange rates report with data from a SQL database. Demonstrates some of the chart capabilities of EPPlus
18	Pivot tables	Demonstrates the Pivot table functionality of EPPlus.
19	Encryption and protection	This sample produces a quiz, where the template workbook is encrypted and password protected.
20	Create filesystem report	Demonstrates usage of styling, printer settings, rich text, pie-, doughnut- and bar-charts, freeze panes
21	VBA - Visual Basic for Applications	Demonstrates EPPlus support for VBA, includes a battleship game

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.

Non windows operating systems.

Non-windows operating systems will requires libgdiplus to be installed. Please use your favorite package manager to install it. For example:

Homebrew on MacOS:

brew install mono-libgdiplus

apt-get:

apt-get install libgdiplus

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