.
Getting Started
The tutorials in this section are designed to make getting started with ExcelWriter quick and easy. They have corresponding downloadable Visual Studio solutions.
Tutorials
Hello World Tutorial
Basic Tutorials
- Simple Expense Summary — The Simple Expense Summary presents sales information for a group in AdventureWorks over a single fiscal year. This sample consists of three tutorials that demonstrate the basics of designing a report with ExcelTemplate. By the end of this sample you'll be able to create reports with data, formatting, formulas and charts with as few as five lines of code.
- Extended Sales Summary — The Extended Sales Summary presents some grouped sales information for a single fiscal quarter. This sample consists of two tutorials that present an introduction to the ExcelApplication object and how to use the ExcelApplication object in combination with ExcelTemplate. By the end of this tutorial, you will be able to create a dynamic template with copied sheets and a coversheet.
- Financial Report — The Financial Report presents assets and losses divided by quarter. This tutorial consists of three parts that cover the use of data marker modifiers and template formats. The tutorial also covers using ExcelApplication to copy between two workbooks. By the end of this tutorial you will be able to format data markers and post-process on multiple workbooks.
More Information
The resources here will help you get the most out of ExcelWriter.
Topics
This topics section offers best practices and guides to compliment the tutorials section. While the tutorials focuses on how to do something, the topics section focuses on when you use certain techniques, and why.
Sample Code
The ExcelWriter Samples include complete code samples with downloadable data, template files, and output files.
Quick Guides
Quick guides are informative pages on a variety of ExcelWriter features and topics.
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
Other Support Resources
Don't see what you are looking for? Check out our other support resources.
Support Site
Knowledge Base Articles
Webinars
Contact Support