Awesome
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
- 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 |
---|
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 |
---|
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 |
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.
Also see wiki on https://github.com/EPPlusSoftware/EPPlus/wiki for more details