This demo is based on the other BasicSteps demo, except that it demonstrates how to use powerful R1C1 formula notation for cell formulas and chart definitions.  Set the UseRCFormulaNotation property to turn on R1C1 formula parsing.

This demo shows a wide range of ExcelApplication functionality in one place.  If you are new to ExcelWriter or looking to brush-up your basic skills, start by reviewing the code for this demo. 

Technical Overview

Click the "View source" link below to see the code that generates the Excel report for this demo.  Here is a list of some of the following capabilities and features that are shown in this demo:

1. Setting cell values
2. Setting cell formulas
3. Adding a basic chart
4. Using the color palette
5. Applying styles and formatting
6. Page setup, including headers and footers
7. Setting "document properties" metadata
8. Adding external pictures to a worksheet
9. Defining clickable hyperlinks
10. Using cell comments
11. Setting Conditional Formatting
12. Defining workbook and worksheet protection

Click to run demo

Copyright 2005 © SoftArtisans, Inc. All Rights Reserved.