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 |
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 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