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.
- Workbook Worksheet and Ranges
- Import and Export
- Styling
- Filters and Validations
- Drawings Charts and Themes
- Formula Calculation
- Tables PivotTables and Slicers
- Encryption Protection and VBA
| 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 |
| 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 |
| 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. |
| 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. |
| 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 |
| No | Sample | Description |
|---|---|---|
| 6.1 | Formula Calculation | shows formula calculation capabilities of EPPlus |
| 6.2 | Dynamic Array Formulas | Example of dynamic array formula calculation |
| 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 |
| 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 |
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.
Also see wiki on https://github.com/EPPlusSoftware/EPPlus/wiki for more details