Advanced
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.
Course info
Rating
Level
Intermediate
Updated
Dec 18, 2014
Duration
2h 15m
Table of contents
Introduction
Excel? Still? Really?
Why Do Users Want Data in Excel?
2m
Options for Delivering Excel
1m
Demo 1: CSV Files
7m
Demo 2: HTML Table
6m
That's Not True, Excel
3m
Introducing EPPlus!
1m
Summary
1m
Just Dump It Out
Quick and Easy
1m
Demo 1: From Text File to Workbook
6m
Demo 2: From Dataset to Workbook
4m
Demo 3: From Array to Workbook
2m
Demo 4: From Collection to Workbook
2m
Summary
1m
I Didn't Really Mean Just Dump It...
All Substance, No Style
1m
Demo 1: Styling a Workbook
10m
Demo 2: Inserting Functions
11m
Exporting Row by Agonizing Row
1m
Demo 3: Controlled Placement
6m
Summary
1m
Get a Head Start With a Template
Let Excel Do What Excel Does
1m
Demo 1: Creating Our Template
5m
Demo 2: Restarting Our Code
12m
Demo 3: So How About Those Tables?
16m
Summary
1m
Can I Get Pie With That?
Description
Course info
Rating
Level
Intermediate
Updated
Dec 18, 2014
Duration
2h 15m
Description
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
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.