|
Demonstrates how to populate a template workbook with ExcelTemplate, and then
programmatically manipulate the populated workbook with ExcelApplication.
Using ExcelTemplate and ExcelApplication objects together can be a powerful
technique that allows you to combine the flexibility and ease of a
template-based design approach with the power of a full Excel API.
Technical Overview
This demo begins with an ExcelTemplate workbook with data markers. First,
the ExcelTemplate object binds data to the data markers while preserving all
existing Excel formats that were in the original template. Then, the
populated workbook is opened as an ExcelApplication Workbook where it can be
programmatically manipulated. ExcelApplication adds a chart.
View source
View template
Click to generate
Copyright 2005 © SoftArtisans, Inc. All Rights
Reserved.
|
