Click here to Skip to main content
15,867,594 members
Articles / Productivity Apps and Services / Microsoft Office / Microsoft Excel

Advanced Excels With EPPlus

Rate me:
Please Sign up or sign in to vote.
5.00/5 (37 votes)
23 May 2018CPOL61 min read 187.9K   7.5K   53  
Create professional-looking Excels (Filters, Charts, Pivot Tables) with EPPlus
The purpose of this article is to demonstrate, by example, how to utilize the advanced features of EPPlus and create professional-looking Excels. I will also tackle EPPlus shortcomings, meaning Excel features that EPPlus doesn't implement, and how to overcome them. I will demonstrate all these things by example. The scenario at hand is we take some data from AdventureWorks2014 and make different Excels out of it. Each Excel demonstrates a different feature, or a different aspect, of EPPlus. For this purpose, the article follows the demo closely. Once you downloaded and run the demo, it will create a bunch of Excel files corresponding to the chapters of the article.

Views

Daily Counts

Downloads

Weekly Counts

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
Web Developer
Israel Israel
https://github.com/yuvalsol

Comments and Discussions