C# - Dynamic Excel Reading with EPPlus [Year of Development: 2019]

About the application technologies and operation:

Technologies:

• Programming Language: C#
• FrontEnd Side: Console Application
• BackEnd Side: .NET Framework 4.6.2.

Installation/ Configuration:

1. Restore necessary Packages, run the following command in PM Console

   Update-Package -reinstall
   

About the application:

Create advanced Excel spreadsheets using .NET, without the need of interop.

EPPlus is a .NET library that reads and writes Excel files using the Office Open XML format (xlsx). EPPlus has no dependencies other than .NET.

EPPlus supports:

• Cell Ranges
• Cell styling (Border, Color, Fill, Font, Number, Alignments)
• Data validation
• Conditional formatting
• Charts
• Pictures
• Shapes
• Comments
• Tables
• Pivot tables
• Protection
• Encryption
• VBA
• Formula calculation
• Many more...

This project started with the source from ExcelPackage. It had the basic functionality needed to read and write a spreadsheet. Advantages over other: EPPlus uses dictionaries to access cell data, making performance a lot better. Complete integration with .NET

The application shows the following:

• How you can Dynamic Reading from an Excel File with EPPlus in an Entity.