[]
Represents a selected range of cells for a sheet.
[TypeConverter(typeof(CellRangeConverter))]
public class CellRange : ISerializable, ISerializeSupport, IEquatable<CellRange>
<TypeConverter(GetType(CellRangeConverter))>
Public Class CellRange
Implements ISerializable, ISerializeSupport, IEquatable(Of CellRange)
| Name | Description |
|---|---|
| CellRange(int, int, int, int) | Creates a range of cells. |
| CellRange(SerializationInfo, StreamingContext) | Creates a new range of cells from serialization. |
| Name | Description |
|---|---|
| Column | Gets the column index of the first cell in the range. |
| ColumnCount | Gets the number of columns in the range. |
| Row | Gets the row index of the first cell in the range. |
| RowCount | Gets the number of rows in the range. |
| Name | Description |
|---|---|
| Contains(CellRange) | Determines whether the range of cells contains another specified range of cells. |
| Contains(int, int) | Determines whether the range of cells contains the cell at the specified row and column. |
| Contains(int, int, int, int) | Determines whether the range of cells contains another specified range of cells. |
| Equals(int, int, int, int) | Determines whether the range of cells is the same as another specified range of cells. |
| Equals(object) | Determines whether the range of cells is the same as another specified range of cells. |
| GetHashCode() | Serves as a hash function for a particular type. |
| GetObjectData(SerializationInfo, StreamingContext) | Populates the SerializationInfo class with information about the settings of the range of cells. |
| IntersectColumn(int) | Determines whether the range of cells intersects the specified column. |
| IntersectRow(int) | Determines whether the range of cells intersects the specified row. |
| IntersectWith(CellRange) | Intersects with the new cell range. |
| Intersects(CellRange) | Determines whether the range of cells intersects the specified range. |
| Intersects(int, int, int, int) | Determines whether the range of cells intersects the specified range. |
| IsValidRange(SheetView) | Determines whether this cell range is valid in the specified sheet. |
| IsValidRange(SheetView, bool) | Determines whether this cell range is valid in the specified sheet and whether to treat as a span. |
| Parse(string) | Converts a string to a cell range. |
| ToString() | Returns the string representation of the cell range. |
| TryParse(string, out CellRange) | Converts a string to a cell range. |
| Name | Description |
|---|---|
| operator ==(CellRange, CellRange) | Determines whether two specified instances of CellRange are equal. |
| operator !=(CellRange, CellRange) | Determines whether two specified instances of CellRange are not equal. |