- GcExcel .NET Overview
- Key Features
- Getting Started
-
Features
-
Worksheet
- Work with Worksheets
-
Range Operations
- Access a Range
- Get Intersection, Union and Offset Range
-
Access Areas in a Range
- Get Special Cell Ranges
- Access Cells, Rows and Columns in a Range
- Get Address of Cell Range
- Cut or Copy Cell Ranges
- Cut or Copy Shape, Slicer, Chart and Picture
- Paste or Ignore Data in Hidden Range
- Find and Replace Data
- Get Row and Column Count
- Hide Rows and Columns
- Insert And Delete Cell Ranges
- Insert and Delete Rows and Columns
- Merge Cells
- Set Values to a Range
- Set Custom Objects to a Range
- Set Row Height and Column Width
- Auto Fit Row Height and Column Width
- Work with Used Range
- Measure Digital Width
- Set Default Values for Cell Range
- Ignore ErrorsIn Cell Range
- Set Cell Background Image for Cell Range
- Freeze Panes in a Worksheet
- Freeze Trailing Panes in a Worksheet
- Customize Worksheets
- Worksheet Views
- Cell Types
- Quote Prefix
- Tags
- Rich Text
- Workbook
- Comments
- Hyperlinks
- Sort
- Filter
- Group
- Conditional Formatting
- Data Validations
- Data Binding
- Digital Signatures
- Formulas
- Custom Functions
- Shapes and Pictures
- Document Properties
- Styles
- Form Controls
- Barcodes
- Theme
- Chart
- Table
- Pivot Table
- Pivot Chart
- Sparkline
- Slicer
- Logging
- Defined Names
-
Worksheet
- Templates
- File Operations
- Release Notes
Access Areas in a Range
While working with a large worksheet having non-contiguous selections, you can access specific areas in a multiple-area range by using the indexer notation of the IAreas interface. The Count property of the IAreas interface represents the area count (number of areas) of the multiple-area range.
The Areas property of the IRange interface represents all the selected ranges in the multiple area range.
Refer to the following example code to access areas in a range.
//area1 is A5:B7.
var area1 = worksheet.Range["A5:B7,C3,H5:N6"].Areas[0];
//set interior color for area1
area1.Interior.Color = Color.Pink;
//area2 is C3.
var area2 = worksheet.Range["A5:B7,C3,H5:N6"].Areas[1];
//set interior color for area2
area2.Interior.Color = Color.LightGreen;
//area3 is H5:N6.
var area3 = worksheet.Range["A5:B7,C3,H5:N6"].Areas[2];
//set interior color for area3
area3.Interior.Color = Color.LightBlue;