These code samples cover how to use ExcelWriter's ExcelTemplate object.

Requirements

Most samples only require Standard Edition, but any that use Enterprise Edition features will be marked.

ExcelTemplate Code Samples

Arrays and Collections as Data Sources

Use a variety of .NET data types to populate ExcelTemplate including string[], ArrayList, and Hashtable.

Chart Report

Any chart that references a range with data markers will have its data source updated when ExcelTemplate imports rows of data. Make changes to a template without making any changes to code.

Data Binding Properties

The DataBindProperties object provides the means to change how data is imported using ExcelTemplate.

Data Marker Options

Data markers have multiple switches and options that are available for use in ExcelTemplate workbooks.

Loan Calculator Spreadsheet

By using Excel's existing internal calculator, ExcelWriter allows you to make calculations in your report.

Sample Expense Report

This sample uses ExcelTemplate to populate a generic expense report template.

String Data Source

Very simple sample that demonstrates how to use strings of data for an Excel report.

Template Grouping and Nesting