Represents a merged region of cells, or cells which share a value and format and appear as one cell when viewed in Microsoft Excel.
Inheritance
- IEnumerable<WorksheetCell>
- IEnumerable
Properties
Section titled "Properties"FirstColumn
Section titled "FirstColumn"Inherited from: WorksheetRegion
Gets the index of the first column in the region.
public int FirstColumn { get; }FirstRow
Section titled "FirstRow"Inherited from: WorksheetRegion
Gets the index of the first row in the region.
public int FirstRow { get; }LastColumn
Section titled "LastColumn"Inherited from: WorksheetRegion
Gets the index of the last column in the region.
public int LastColumn { get; }LastRow
Section titled "LastRow"Inherited from: WorksheetRegion
Gets the index of the last row in the region.
public int LastRow { get; }Worksheet
Section titled "Worksheet"Inherited from: WorksheetRegion
Gets the worksheet on which the region resides.
public Worksheet Worksheet { get; }CellFormat
Section titled "CellFormat"Gets the cell formatting for the merged cell region.
public IWorksheetCellFormat CellFormat { get; }Comment
Section titled "Comment"Gets or sets the comment for the merged cells region.
public WorksheetCellComment Comment { get; set; }Formula
Section titled "Formula"Gets the formula which has been applied to the merged region.
public Formula Formula { get; }Value
Section titled "Value"Gets or sets the value of the merged cell region.
public object Value { get; set; }Methods
Section titled "Methods"Equals(object)
Section titled "Equals(object)"Inherited from: WorksheetRegion
Determines whether the specified value equals this .
public override bool Equals(object obj)Parameters
- obj:
object
Returns any
GetHashCode()
Section titled "GetHashCode()"Inherited from: WorksheetRegion
Gtes the hash code for the .
public override int GetHashCode()Returns any
ToString()
Section titled "ToString()"Inherited from: WorksheetRegion
Gets the string representation of the range of cells in the region.
public override string ToString()Returns any
ApplyArrayFormula(string)
Section titled "ApplyArrayFormula(string)"Inherited from: WorksheetRegion
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)"Inherited from: WorksheetRegion
Applies a formula to the region of cells.
public void ApplyFormula(string value)Parameters
- value:
string
Returns any
FormatAsTable(bool)
Section titled "FormatAsTable(bool)"Inherited from: WorksheetRegion
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)"Inherited from: WorksheetRegion
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()"Inherited from: WorksheetRegion
Gets the bounds of the region in twips (1/20th of a point).
public Rect GetBoundsInTwips()Returns any
GetBoundsInTwips(PositioningOptions)
Section titled "GetBoundsInTwips(PositioningOptions)"Inherited from: WorksheetRegion
Gets the bounds of the region in twips (1/20th of a point).
public Rect GetBoundsInTwips(PositioningOptions options)Parameters
- options:
PositioningOptions
Returns any
ToString(CellReferenceMode, bool)
Section titled "ToString(CellReferenceMode, bool)"Inherited from: WorksheetRegion
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)"Inherited from: WorksheetRegion
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
Returns any
GetResolvedCellFormat()
Section titled "GetResolvedCellFormat()"Gets the resolved cell formatting for this merged cell region.
public IWorksheetCellFormat GetResolvedCellFormat()