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

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.

Hot Cell Sample - Excel Drill Down

This sample demonstrates an application of HotCell Technology that actively downloads reports from a web server based on selections made on a client-side Excel spreadsheet.

Hot Cell Sample - Excel Web form

 This demo downloads a workbook of employee information populated by ExcelTemplate. From within Excel, edit employee address information and update the server-side database.

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

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

XML Data Import

Parse an XML file and put the data into arrays for use in an ExcelTemplate report.