View Source

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.

ExcelWriter v8 Docs > Extended Sales Summary > ExtendedSalesSummary2.png

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#. This version of the code uses CSV files as a data source as opposed to a SQL query (like in the tutorial).