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 Sauer is the founder of Bam! Pow! Software Solutions, LLC. He worked for Johnson Investment Counsel, Inc. for over 20 years prior to founding Bam! Pow! in 2014. During his time with JIC, Jason filled a variety of roles, from IT intern to Manager of the Information Systems department. He designed and developed much of the software used to run the firm, creating solutions ranging from portfolio management and accounting systems to contact relationship management and trading systems. Those ... more

Ready to upskill? Get started