Working with Ranges
The NamedRange and Range classes contain the methods and properties you use to perform tasks with ranges.
| Task | Procedure |
|---|---|
| Access a range and set the value. | How to: Programmatically Refer to Worksheet Ranges in Code |
| Fill a range based on an initial value. | How to: Programmatically Automatically Fill Ranges with Incrementally Changing Data |
| Get and set date values in cells. | How to: Programmatically Store and Retrieve Date Values in Excel Ranges |
| Apply styles to cells in a region. | How to: Programmatically Apply Styles to Ranges in Workbooks |
| Search for text in worksheet ranges. | How to: Programmatically Search for Text in Worksheet Ranges |
| Apply color to text in a range of cells. | How to: Programmatically Apply Color to Excel Ranges |
| Run Excel calculations programmatically. | How to: Programmatically Run Excel Calculations Programmatically |
| Display a string in a cell. | How to: Programmatically Display a String in a Worksheet Cell |
For more information about Excel tasks and the Excel object model, see Excel Object Model Overview.
In some cases, the ways that you perform these tasks in VSTO Add-ins is different from the ways that you perform them in document-level customizations.
Automating Excel by Using Extended Objects
Working with Worksheets
Working with Workbooks
Using Windows Forms Controls on Excel Worksheets
Show: