Programmer's Reference
ExcelWriter provides two development solutions that can be used
separately or together:
- ExcelTemplate
Introduction to ExcelTemplate: Create a Spreadsheet with ExcelTemplate
ExcelTemplate is the main class for template-driven document generation. This object opens an
ExcelWriter template file, populates it with data from a specified data source,
and generates a new Excel workbook.
- ExcelApplication
Introduction to ExcelApplication: Create a Spreadsheet with ExcelApplication
ExcelApplication is the main class for pure code-based workbook generation.
This class is an engine used to open, create, and write (save or stream to a browser)
workbooks. A single instance of ExcelApplication can generate multiple Excel workbooks.
ExcelTemplate provides an intuitive high-performance way
to import database values to a spreadsheet, but cannot otherwise modify a spreadsheet at
runtime. ExcelApplication 's rich object model allows you to modify every aspect
of the spreadsheet at runtime. You can take advantage of the features of both
ExcelApplication and ExcelTemplate by using them
together. For example, you can use ExcelTemplate to open and
populate an ExcelWriter template, then pass the populated workbook to
ExcelApplication and add a chart. Or, you could generate a template
spreadsheet with ExcelApplication and pass the spreadsheet to
ExcelTemplate to be populated.
Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.
|