.
Sample Code
ExcelTemplate 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.
ExcelApplication Samples
- Basic Steps — This sample covers a wide range of basic ExcelApplication functionality. Excellent for getting started or brushing up on basic skills.
- Basic Steps R1C1 — Same as Basic Steps except all the formulas and references are in R1C1 notation.
- Application to Template Sample — Create a template file for ExcelTemplate using ExcelApplication to write in data markers.
- Template to Application Sample — Populate a template with ExcelTemplate and then programmatically manipulate or 'post process' the workbook with ExcelApplication.
- Multiple Chart Report — Import data to an existing template with multiple charts. Manipulate existing charts with ExcelApplication.
- Scatter Chart Report — See how to create Scatter Charts with ExcelApplication.
- Two Axis Chart Sample — Create a chart with ExcelApplication that has two axes: primary axis and secondary axis.
- Grouping and Subtotals — Add Excel's grouping and outlining functionality to a workbook with ExcelWriter to display nested data.
- Data Validation — Define and apply data validation rules to cells with ExcelApplication.
- Excel to DataTable Sample — Extract Excel data into a DataTable
- Sales Commission Report — An example of a report created with ExcelWriter that compares previous year and year-to-date sales data for a sales team.