Quick Guides

Guides

These tutorials show how to use some of the more advanced features of ExcelWriter.

Most of these features require ExcelWriter Enterprise Edition.

ExcelApplication Guides

Addressing Cells

Formulas

Styles in ExcelWriter

Number Formats

The Color Palette

Modifying an Existing Spreadsheet

Importing Data

Charts in ExcelApplication

Output Options for ExcelApplication

Copying Data From a Worksheet

Multilingual Support

Areas and Ranges

Drawing Objects

Formatting Headers and Footers

Protecting Your Worksheet

Creating a Basic PivotTable

Convert strings to formatted numerical values

ExcelTemplate Guides

How to Use Templates

Creating Data Markers

Stretching Formulas

Using Charts with ExcelTemplate

Drawing Objects and Data Markers

Using an Array as a Data Source

Using a Database as a Data Source

Using Grouping and Nesting with ExcelTemplate

Templates and PivotTables

ExcelTemplate Output Options

Space Shortcuts

Page tree