Skip to main content
Row

IRangeProvider Members

Provides properties and methods to get cell ranges.

Properties

Name Description
Item[String] Gets a cell range by its reference string.

Methods

Name Description
FromLTRB(Int32, Int32, Int32, Int32) Returns a cell range by the indexes of the bounding rows and columns.
GetColumnIndexByName(String) Returns the index of the column with the specified heading in the A1 reference style.
GetColumnNameByIndex(Int32) Returns the heading of the column with the specified index.
Parse(String, ReferenceStyle) Returns a cell range by its reference string in the specified reference style.
Parse(String) Returns a cell range by its reference string in the A1 reference style.
Union(CellRange[]) Creates a complex range that is the union of multiple ranges.
Union(IEnumerable<CellRange>) Creates a complex range that is the union of multiple ranges.
ValidateReference(String, ReferenceStyle) Validates the cell reference in accordance with the specified cell reference style.
ValidateReference(String) Validates the cell reference in accordance with the cell reference style used in the workbook.
See Also