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, table or a pivot 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 |
| 22 | Ignore errors | Various samples on how to ignore error on cells. |
| 23 | Comments | Sample showing how to add notes and threaded comments. |
| 24 | Slicers | Sample showing how to add Pivot Table slicers and Tabel slicers |
| 25 | Export to/from DataTable | Sample showing import/export rangedata with System.Data.DataTable |
| 26 | Form controls | Sample showing how to add differnt form controls and how to group drawings. |
| 27 | Custom styles for tables and slicers | Sample showing how to create custom styles from tables, pivot tables and slicers. |
| 28 | Tables | Sample showing how to work with tables. |
| 29 | External links | Shows how to work with links to external workbooks |
| 30 | Sorting Ranges | Shows how to work with the Sort method for ranges and tables |
| 31 | Html Export | Shows how to export tables and ranges to HTML |
| 32 | Json Export | Shows how to export tables and ranges to JSON |
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
For Docker, see our Docker file samples
Also see wiki on https://github.com/EPPlusSoftware/EPPlus/wiki for more details