This is a sales summary for multiple groups in AdventureWorks for a single fiscal quarter, which is extended from the Simple Expense Summary. The Extended Sales Summary introduces preprocessing a template file with the ExcelApplication object and then postprocessing with ExcemTemplate.

                           

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 code used in these tutorials is available for download in C#. There are two versions of the download:

  • Version 1: Regular, SQL Server AdventureWorks2008R2 based project
  • Version 2: The query data is stored in CSV files and the project is configured to read the data from the CSV files rather than a live database.