Click or drag to resize

CellRange Methods

The CellRange type exposes the following members.

Methods
  NameDescription
Public methodCalculate
Calculates formula for every excel cell in this range.
(Overrides AbstractRangeCalculate.)
Public methodClear
Clears the range (content, formatting, comment, hyperlink or all).
(Inherited from AbstractRange.)
Public methodCopyTo(String)
Copies this cell range to another position in the same worksheet or in another worksheet.
Public methodCopyTo(Int32, Int32)
Copies this cell range to another position in the same worksheet.
Public methodCopyTo(ExcelWorksheet, String)
Copies this cell range to another worksheet.
Public methodCopyTo(ExcelWorksheet, Int32, Int32)
Copies this cell range to another worksheet.
Public methodEquals
Determines whether the specified Object is equal to this CellRange instance.
(Overrides ObjectEquals(Object).)
Public methodCode exampleFilter

Gets the AutoFilter active on the parent worksheet (Filter) if active Range is equal to this CellRange; otherwise, a new AutoFilter instance, which is set as active on the parent worksheet.

AutoFilter is used to store filter settings and to apply filter on this range of cells.

Public methodCode exampleFilter(Boolean)

Gets the AutoFilter active on the parent worksheet (Filter) if active Range is equal to this CellRange and parameter active is ; otherwise, a new AutoFilter instance, which is set as active on the parent worksheet if parameter active is .

AutoFilter is used to store filter settings and to apply filter on this range of cells.

Public methodFindText(String, Int32, Int32)
Finds the first occurrence of the specified text in the current cell range.
Public methodFindText(Regex, Int32, Int32)
Finds the first occurrence which matches the specified Regex in the current cell range.
Public methodFindText(String, Boolean, Int32, Int32)
Finds the first occurrence of the specified text in the current cell range.
Public methodFindText(String, Boolean, Boolean, Int32, Int32)
Finds the first occurrence of the specified text in the current cell range.
Public methodGetCharacters(Int32)
Returns a FormattedCharacterRange object that represents a range of characters within the cell text. The range starts at a specified character position. Not supported in ODS and XLS.
(Inherited from AbstractRange.)
Public methodGetCharacters(Int32, Int32)
Returns a FormattedCharacterRange object that represents a range of characters within the cell text. The range starts at a specified character position and has a specified length. Not supported in ODS and XLS.
(Inherited from AbstractRange.)
Public methodGetEnumerator
Returns an enumerator for the CellRange (all cells).
Public methodGetHashCode
Returns a hash code for this CellRange instance.
(Overrides ObjectGetHashCode.)
Public methodGetReadEnumerator
Returns enumerator for the CellRange (only allocated cells).
Public methodGetSubrange(String)
Returns new cell range using A1 style notation.
Public methodCode exampleGetSubrange(String, String)
Returns new cell range using start and end position.
Public methodGetSubrangeAbsolute
Returns new cell range using absolute indexing.
Public methodGetSubrangeRelative
Returns new cell range using relative indexing.
Public methodInsert
Inserts a range by shifting cells in the specified direction.
(Overrides AbstractRangeInsert(InsertShiftDirection).)
Public methodOverlaps
Checks if this cell range overlaps with another cell range.
Public methodStatic memberPositionToRowColumn
Converts position string ("A1", "BN27", etc.) to row and column index.
Public methodRemove
Removes a range by shifting cells in the specified direction.
(Overrides AbstractRangeRemove(RemoveShiftDirection).)
Public methodReplaceText(String, String)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
(Inherited from AbstractRange.)
Public methodReplaceText(String, String, Boolean)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
(Inherited from AbstractRange.)
Public methodReplaceText(String, String, Boolean, Boolean)
Replaces all occurrences of the specified text with another text in the current AbstractRange.
(Inherited from AbstractRange.)
Public methodStatic memberRowColumnToPosition
Converts row and column index to position string ("A1", "BN27", etc.).
Public methodSetBorders Obsolete.
Sets borders on one or more excel cells, taking cell position into account.
(Inherited from AbstractRange.)
Public methodCode exampleSort

Gets the SortState active on the parent worksheet (Sort) if active Range is equal to this CellRange and parameter active is ; otherwise, a new SortState instance, which is set as active on the parent worksheet if parameter active is .

SortState is used to store sort settings and to apply sort on this range of cells.

Public methodToString
Returns a String that represents this AbstractRange instance.
(Inherited from AbstractRange.)
Top
Explicit Interface Implementations
See Also