Work 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 |
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.
Related content
Povratne informacije
https://aka.ms/ContentUserFeedback.
Stiže uskoro: Tokom 2024. godine postepeno ćemo ukidati probleme sa uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zameniti ga novim sistemom povratnih informacija. Dodatne informacije potražite u članku:Prosledite i prikažite povratne informacije za