Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Excerpt

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.

Note

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 introduces preprocessing a template file with the ExcelApplication object and then postprocessing with ExcemTemplate.

Image Removed Image Removed

Extended Sales Summary Tutorials:

...

Tutorials:

Info
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

The Extended Sales Summary sample code is available for download in C#. There are two versions of the download:

  • Version 1: Regular, SQL Server AdventureWorks based project
  • ExcelWriter_Basic_Tutorials.zip.