Represents a row in a Microsoft Excel worksheet.
Inheritance
object
Properties
Section titled "Properties"CellFormat
Section titled "CellFormat"Inherited from: RowColumnBase
Gets the default cell format for cells in this row or column.
public IWorksheetCellFormat CellFormat { get; }Hidden
Section titled "Hidden"Inherited from: RowColumnBase
Gets or sets the value indicating whether the row or column is hidden.
public bool Hidden { get; set; }OutlineLevel
Section titled "OutlineLevel"Inherited from: RowColumnBase
Gets or sets the outline level for the row or column.
public int OutlineLevel { get; set; }Worksheet
Section titled "Worksheet"Inherited from: RowColumnBase
Gets the worksheet to which the row or column belongs.
public Worksheet Worksheet { get; }Cells
Section titled "Cells"Gets the collection of cells in the row.
public WorksheetCellCollection Cells { get; }Height
Section titled "Height"Gets or sets the height of the row in twips (1/20th of a point).
public int Height { get; set; }Index
Section titled "Index"Gets the 0-based index of the row in the worksheet.
public override int Index { get; }Methods
Section titled "Methods"GetResolvedCellFormat()
Section titled "GetResolvedCellFormat()"Inherited from: RowColumnBase
Gets the resolved cell formatting for the cells in the row or column.
public IWorksheetCellFormat GetResolvedCellFormat()Returns any
ApplyCellFormula(int, string, CellReferenceMode?)
Section titled "ApplyCellFormula(int, string, CellReferenceMode?)"Applies a formula to the cell at the specified column index.
public void ApplyCellFormula(int columnIndex, string formula, CellReferenceMode? cellReferenceMode = null)Parameters
- columnIndex:
int - formula:
string - cellReferenceMode:
CellReferenceMode?
Returns any
GetCellAssociatedDataTable(int)
Section titled "GetCellAssociatedDataTable(int)"Gets the data table to which the cell at the specified index belongs.
public WorksheetDataTable GetCellAssociatedDataTable(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellAssociatedMergedCellsRegion(int)
Section titled "GetCellAssociatedMergedCellsRegion(int)"Gets the merged cells region which contains the cell at the specified index, or null if the cell is not merged.
public WorksheetMergedCellsRegion GetCellAssociatedMergedCellsRegion(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellAssociatedTable(int)
Section titled "GetCellAssociatedTable(int)"Gets the to which the cell at the specified index belongs.
public WorksheetTable GetCellAssociatedTable(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellBoundsInTwips(int)
Section titled "GetCellBoundsInTwips(int)"Gets the bounds of the cell at the specified column index in twips (1/20th of a point).
public Rect GetCellBoundsInTwips(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellBoundsInTwips(int, PositioningOptions)
Section titled "GetCellBoundsInTwips(int, PositioningOptions)"Gets the bounds of the cell at the specified column index in twips (1/20th of a point).
public Rect GetCellBoundsInTwips(int columnIndex, PositioningOptions options)Parameters
- columnIndex:
int - options:
PositioningOptions
Returns any
GetCellComment(int)
Section titled "GetCellComment(int)"Gets or sets the comment applied to the cell at the specified column index.
public WorksheetCellComment GetCellComment(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellConditionalFormat(int)
Section titled "GetCellConditionalFormat(int)"Gets the cell conditional format for the cell at the specified column index.
public CellConditionalFormat GetCellConditionalFormat(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellFormat(int)
Section titled "GetCellFormat(int)"Gets the cell formatting for the cell at the specified column index.
public IWorksheetCellFormat GetCellFormat(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellFormula(int)
Section titled "GetCellFormula(int)"Gets the formula which has been applied to the cell at the specified column index.
public Formula GetCellFormula(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellHyperlink(int)
Section titled "GetCellHyperlink(int)"Gets the effective hyperlink on the cell at the specified index.
public WorksheetHyperlink GetCellHyperlink(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellText(int)
Section titled "GetCellText(int)"Gets the display text in the cell at the specified index.
public string GetCellText(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetCellText(int, TextFormatMode)
Section titled "GetCellText(int, TextFormatMode)"Gets the text in the cell at the specified index.
public string GetCellText(int columnIndex, TextFormatMode textFormatMode)Parameters
- columnIndex:
int - textFormatMode:
TextFormatMode
Returns any
GetCellValue(int)
Section titled "GetCellValue(int)"Gets the value of the cell at the specified column index.
public object GetCellValue(int columnIndex)Parameters
- columnIndex:
int
Returns any
GetResolvedCellFormat(int)
Section titled "GetResolvedCellFormat(int)"Gets the resolved cell formatting for the cell at the specified column index.
public IWorksheetCellFormat GetResolvedCellFormat(int columnIndex)Parameters
- columnIndex:
int
Returns any
SetCellComment(int, WorksheetCellComment)
Section titled "SetCellComment(int, WorksheetCellComment)"Sets the comment applied to the cell at the specified column index.
public void SetCellComment(int columnIndex, WorksheetCellComment comment)Parameters
- columnIndex:
int - comment:
WorksheetCellComment
Returns any
SetCellValue(int, object)
Section titled "SetCellValue(int, object)"Sets the value of a cell at the specified column index.
public void SetCellValue(int columnIndex, object value)Parameters
- columnIndex:
int - value:
object
Returns any
TryGetCellFormat(int, out IWorksheetCellFormat)
Section titled "TryGetCellFormat(int, out IWorksheetCellFormat)"Gets the cell formatting for the cell at the specified column index if it is allocated.
public bool TryGetCellFormat(int columnIndex, out IWorksheetCellFormat cellFormat)Parameters
- columnIndex:
int - cellFormat:
IWorksheetCellFormat
Returns any
ValidateCellValue(int)
Section titled "ValidateCellValue(int)"Returns a boolean indicating if the value of the cell is valid considering its associated
public bool ValidateCellValue(int columnIndex)Parameters
- columnIndex:
int