The easiest way to create Microsoft Excel documents using .NET

Microsoft Excel is one of the most popular applications in business. Most people are familiar with it because it’s very easy to use and productive.Excel-icon

One of the most important things in developing enterprise applications is integration and developers should integrate their applications with other popular apps. For example, exporting data as PDF is something which is critical in some of enterprise applications because PDF is standard and most people have Adobe Acrobat these days; so if user wants to send data to another person as a report or something, the data must be exported to a standard format so the person can open it!

Excel is now popular especially in accounting or any other applications that have complex calculations. Since the Excel is so good, companies have to integrate their apps with Excel too!

I’m currently developing an enterprise application and I needed to add Microsoft Excel integration to it because most of our users request this feature!

As a matter of fact, I don’t want to describe how you can do it step-by-step. What I want to do right now is to introduce an open source .NET library that can be used in order to export data to Microsoft excel and the name of the library is: EPPlus.

EPPlus is a .net library that reads and writes Excel 2007/2010 files using the Open Office Xml format (xlsx).

EPPlus supports:

  • Cell Ranges
  • Cell styling (Border, Color, Fill, Font, Number, Alignments)
  • Charts
  • Pictures
  • Shapes
  • Comments
  • Tables
  • Protection
  • Encryption
  • Many more…

Advantages over others:

  • Totally rewritten using dictionaries
  • Can now load 50 000 cells in seconds
  • Complete integration with .NET
  • Loads of extensions  

One of the good points about EPPlus is the LINQ integrations and IEnumerable support so you can use whatever data source want!

Another great feature of this library is the ability to create charts right from your code!

For more information and samples about this library, check its page CodePlex:

I hope it helps.