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.
Extended Sales Summary Tutorials:
- 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 ExcelTemplate
- Part 2 - Creating a Coversheet
- Using ExcelApplication to create and populate a coversheet that includes user-supplied name, the current date, and a selected picture