Page tree
Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 14 Next »

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
Icon

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.
  • No labels