The tutorials in this section are designed to make getting started with ExcelWriter quick and easy. They have corresponding downloadable Visual Studio solutions.
Hello World Tutorial
- 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.
The resources here will help you get the most out of ExcelWriter.
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.
The ExcelWriter Samples include complete code samples with downloadable data, template files, and output files.
Quick guides are informative pages on a variety of ExcelWriter features and topics.
- Addressing Cells
- 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
Other Support Resources
Don't see what you are looking for? Check out our other support resources.
Knowledge Base Articles