Home

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

  1. Workbook Worksheet and Ranges
  2. Import and Export
  3. Styling
  4. Filters and Validations
  5. Drawings Charts and Themes
  6. Formula Calculation
  7. Tables PivotTables and Slicers
  8. Encryption Protection and VBA

Workbook Worksheet and Ranges

NoSampleDescription
1.01Getting startedBasic usage of EPPlus: create a workbook, fill with data and some basic styling
1.02Read an existing workbookRead in a workbook
1.03Using async awaitAsync Await in Epplus
1.04Fill copy and sort rangesDifferent range operations
1.05Notes and threaded commentsHandling notes and Comments in Epplus
1.06Sales report with hyperlinksHyperlink and database guide
1.07Performance writeLoading and writing in a performant way
1.08Performance read using linqUsing Linq on Cells
1.09External linksExternal links to other workbooks
1.10Ignore errorsHow to ignore errors on ranges

Import and Export

NoSampleDescription
2.1Load data from collectionLoad data into worksheet from various types of objects. It also demonstrates the Autofit columns feature.
2.2Export data to collectionDemonstrates Export ranges and tables into an IEnumerable<T> where T is a class type.
2.3Import export csv filesAsync Await in Epplus
2.4Import export DataTableDifferent range operations
2.5Export to htmlHandling notes and Comments in Epplus
2.6Export to jsonHyperlink and database guide

Styling

NoSampleDescription
3.1Styling basicsDemonstrates how to apply different styling on cells including Fills, Fonts etc.
3.2Conditional formattingDemonstrates all conditional formatting and how to apply styling/Formatting.
3.3Fx report from databaseThis sample produces a workbook with foreign exchange rates.
3.4Create a file system reportDemonstrates usage of styling, printer settings, rich text, pie-, doughnut- and bar-charts, freeze panes.

Filters and Validations

NoSampleDescription
4.1Data ValidationsDemonstrates how to apply different styling on cells including Fills, Fonts etc.
4.2FilterDemonstrates all conditional formatting and how to apply styling/Formatting.

Drawings Charts and Themes

NoSampleDescription
5.1Shapes and imagesHow to create shapes and images using EPPlus and apply effects
5.2Open workbook add data and chartOpen an existing workbook with EPPlus, add data and charts
5.3Charts And themesDemonstrates how to use various types of charts, chart styling and themes
5.4Sparklinesdemonstrates EPPlus support for Sparklines
5.5Form controlsdemonstrates how to Add form controls, like drop-downs, buttons and radiobuttons to a worksheet and grouping drawings via VBA Macro

Formula Calculation

NoSampleDescription
6.1Formula Calculationshows formula calculation capabilities of EPPlus
6.2Dynamic Array FormulasExample of dynamic array formula calculation

Tables Pivot Tables and Slicers

NoSampleDescription
7.1TablesSamples of creating and calculating tables in Epplus
7.2Pivot TablesPivot table functionality of EPPlus
7.3SlicersSlicers for table and pivot table slicers
7.4Custom Named StylesExample for how to create custom slicer styles

Encryption Protection and VBA

NoSampleDescription
8.1Encryption and ProtectionSample of encryption and password protection
8.2VBAAn 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