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

...

Image Removed                            Image Removed

. 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 Tutorials:*

...

...

    • customize a template and using ExcelTemplate to dynamically bind data.
  • Part 2 -

...

...

  • Cover sheet

      ...

        • Using ExcelApplication to create

      ...

        • a cover sheet with images, links, and formatted text at run time.
      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 code used in these tutorials Extended Sales Summary sample code is available for download in C#. There are two versions of the download:

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