Expanded Library

Creating Server-Side Excel Workbooks

by Jason Sauer

In this course we will discuss the desire, and in many cases the need, that many users have for receiving data from your applications in Excel format. We will talk about a few of the traditional methods used to deliver Excel data and introduce some newer methods that make this process not only easier, but more powerful and flexible as well.

What you'll learn

Developers often need to be able to provide data from their web applications in Excel format for users to interact with. This course introduces .NET developers to the EPPlus library, a package available on CodePlex that encapsulates the functionality of Office Open XML in a way that makes creating Excel workbooks on the server very simple.

About the author

Jason is the founder of Bam! Pow! Software Solutions, LLC. He has over 20 years experience as a business analyst, project manager and software developer. Jason has written numerous applications for the financial industry ranging from portfolio management and accounting systems to contact relationship management systems to trading systems.

Ready to upskill? Get started