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.

...

  • Part 1 - Creating a Dynamic Template
    • Learning how to use ExcelApplication to make copies of an Excel file based on user selection, and then populating the modified file using ExcelTemplatecustomize a template and using ExcelTemplate to dynamically bind data.
  • Part 2 - Creating a CoversheetCover sheet
    • Using ExcelApplication to create and populate a coversheet that includes user-supplied name, the current date, and a selected picturea cover sheet with images, links, and formatted text at run time.
Info

The Extended Sales Summary sample code is available for download in ExcelWriter_Basic_Tutorials C#.zip.