Represents a rectangular region of cells on a worksheet.
Inheritance
object
Classes that extend this class.
Derived Classes- IEnumerable<WorksheetCell>
- IEnumerable
Constructors
Section titled "Constructors"constructor
public WorksheetRegion(Worksheet worksheet, int firstRow, int firstColumn, int lastRow, int lastColumn)Returns WorksheetRegion
Properties
Section titled "Properties"FirstColumn
Section titled "FirstColumn"Gets the index of the first column in the region.
public int FirstColumn { get; }FirstRow
Section titled "FirstRow"Gets the index of the first row in the region.
public int FirstRow { get; }LastColumn
Section titled "LastColumn"Gets the index of the last column in the region.
public int LastColumn { get; }LastRow
Section titled "LastRow"Gets the index of the last row in the region.
public int LastRow { get; }Worksheet
Section titled "Worksheet"Gets the worksheet on which the region resides.
public Worksheet Worksheet { get; }Methods
Section titled "Methods"ApplyArrayFormula(string)
Section titled "ApplyArrayFormula(string)"Applies a array formula to the region of cells.
public void ApplyArrayFormula(string value)Parameters
- value:
string
Returns any
ApplyFormula(string)
Section titled "ApplyFormula(string)"Applies a formula to the region of cells.
public void ApplyFormula(string value)Parameters
- value:
string
Returns any
Equals(object)
Section titled "Equals(object)"Determines whether the specified value equals this .
public override bool Equals(object obj)Parameters
- obj:
object
Returns any
FormatAsTable(bool)
Section titled "FormatAsTable(bool)"Formats the region as a table and adds an associated to the collection.
public WorksheetTable FormatAsTable(bool tableHasHeaders)Parameters
- tableHasHeaders:
bool
Returns any
FormatAsTable(bool, WorksheetTableStyle)
Section titled "FormatAsTable(bool, WorksheetTableStyle)"Formats the region as a table and adds an associated to the collection.
public WorksheetTable FormatAsTable(bool tableHasHeaders, WorksheetTableStyle tableStyle)Parameters
- tableHasHeaders:
bool - tableStyle:
WorksheetTableStyle
Returns any
GetBoundsInTwips()
Section titled "GetBoundsInTwips()"Gets the bounds of the region in twips (1/20th of a point).
public Rect GetBoundsInTwips()Returns any
GetBoundsInTwips(PositioningOptions)
Section titled "GetBoundsInTwips(PositioningOptions)"Gets the bounds of the region in twips (1/20th of a point).
public Rect GetBoundsInTwips(PositioningOptions options)Parameters
- options:
PositioningOptions
Returns any
GetHashCode()
Section titled "GetHashCode()"Gtes the hash code for the .
public override int GetHashCode()Returns any
ToString()
Section titled "ToString()"Gets the string representation of the range of cells in the region.
public override string ToString()Returns any
ToString(CellReferenceMode, bool)
Section titled "ToString(CellReferenceMode, bool)"Gets the string representation of the range of cells in the region.
public string ToString(CellReferenceMode cellReferenceMode, bool includeWorksheetName)Parameters
- cellReferenceMode:
CellReferenceMode - includeWorksheetName:
bool
Returns any
ToString(CellReferenceMode, bool, bool, bool)
Section titled "ToString(CellReferenceMode, bool, bool, bool)"Gets the string representation of the range of cells in the region.
public string ToString(CellReferenceMode cellReferenceMode, bool includeWorksheetName, bool useRelativeColumn, bool useRelativeRow)Parameters
- cellReferenceMode:
CellReferenceMode - includeWorksheetName:
bool - useRelativeColumn:
bool - useRelativeRow:
bool