Intro

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

Here are some of the features shown in the sample:

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

Code

Downloads

Output: BasicSteps_output.xlsx

Image: OWlogo.gif