Get Address, Cell Count, Offset, Entire Column, and Entire Row of the Range

Possible Usage Scenarios

Aspose.Cells provides the Range object, which has various utility methods that facilitate the user to work with Excel ranges easily. This article illustrates the usage of the following methods or properties of the Range object.

• Address
  Gets the address of the range.

• Cell Count
  Gets the total cell count in the range.

• Offset
  Gets a range by offset.

• Entire Column
  Gets a Range object that represents the entire column (or columns) that contains the specified range.

• Entire Row
  Gets a Range object that represents the entire row (or rows) that contains the specified range.

Get Address, Cell Count, Offset, Entire Column, and Entire Row of the Range

The following sample code demonstrates the usage of the methods and properties discussed above. Please refer to the console output below for reference.

Sample Code

Console Output

Creating Range A1:B3
Range Address: A1:B3
Cell Count: 6
----------------------
Creating Range A1
Offset: C3
Entire Column: A:A
Entire Row: 1:1
----------------------