View Source

The Extended Sales Summary presents some grouped sales information for a single fiscal quarter. This sample consists of two tutorials that present an introduction to the ExcelApplication object and how to use the ExcelApplication object in combination with ExcelTemplate. By the end of this tutorial, you will be able to create a dynamic template with copied sheets and a coversheet.

This example assumes an understanding of ExcelTemplate. If you are not familiar with how to set up an Excel template with data markers, please go through the Simple Expense Summary first.

Extended Sales Summary Tutorials:

Part 1 - Copying Sheets
- Learning how to use ExcelApplication to make copies of an Excel file based on user selection, and then populating the modified file using ExcelTemplate
Part 2 - Adding a Coversheet
- Using ExcelApplication to create and populate a coversheet that includes user-supplied name, the current date, and a selected picture

The sample Extended Sales Summary code is available in the ExcelWriter Basic Tutorials C#.