View Source

The Extended Sales Summary presents some grouped sales information for a single fiscal quarter. This sample consists of two tutorials that presents an introduction to the ExcelApplication object, as well as how to create a report using a dynamic number of copied worksheets.

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.

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#.