ExcelApplication Sample Code

These samples cover how to use ExcelWriter's ExcelApplication object. All of these samples require OfficeWriter Enterprise Edition to be installed.

ExcelApplication Code Samples

This sample covers a wide range of basic ExcelApplication functionality. Excellent for getting started or brushing up on basic skills.

Same as Basic Steps except all the formulas and references are in R1C1 notation.

Create a template file for ExcelTemplate using ExcelApplication to write in data markers.

Populate a template with ExcelTemplate and then programmatically manipulate or 'post process' the workbook with ExcelApplication.

Import data to an existing template with multiple charts. Manipulate existing charts with ExcelApplication.

See how to create Scatter Charts with ExcelApplication.

Create a chart with ExcelApplication that has two axes: primary axis and secondary axis.

Add Excel's grouping and outlining functionality to a workbook with ExcelWriter to display nested data.

Define and apply data validation rules to cells with ExcelApplication.

Extract Excel data into a DataTable

An example of a report created with ExcelWriter that compares previous year and year-to-date sales data for a sales team.