Version

WorksheetRow Class Members

The following tables list the members exposed by WorksheetRow.

Public Properties
 NameDescription
Public PropertyCellFormatGets the default cell format for cells in this row or column. (Inherited from Infragistics.Documents.Excel.RowColumnBase)
Public PropertyCellsGets the collection of cells in the row.  
Public PropertyHeightGets or sets the height of the row in twips (1/20th of a point).  
Public PropertyHiddenGets or sets the value indicating whether the row or column is hidden. (Inherited from Infragistics.Documents.Excel.RowColumnBase)
Public PropertyIndexOverridden. Gets the 0-based index of the row in the worksheet.  
Public PropertyOutlineLevelGets or sets the outline level for the row or column. (Inherited from Infragistics.Documents.Excel.RowColumnBase)
Public PropertyWorksheetGets the worksheet to which the row or column belongs. (Inherited from Infragistics.Documents.Excel.RowColumnBase)
Public Methods
 NameDescription
Public MethodApplyCellFormulaApplies a formula to the cell at the specified column index.  
Public MethodGetCellAssociatedDataTableGets the data table to which the cell at the specified index belongs.  
Public MethodGetCellAssociatedMergedCellsRegionGets the merged cells region which contains the cell at the specified index, or null if the cell is not merged.  
Public MethodGetCellAssociatedTableGets the WorksheetTable to which the cell at the specified index belongs.  
Public MethodGetCellBoundsInTwipsOverloaded. Gets the bounds of the cell at the specified column index in twips (1/20th of a point).  
Public MethodGetCellCommentGets or sets the comment applied to the cell at the specified column index.  
Public MethodGetCellConditionalFormatGets the cell conditional format for the cell at the specified column index.  
Public MethodGetCellFormatGets the cell formatting for the cell at the specified column index.  
Public MethodGetCellFormulaGets the formula which has been applied to the cell at the specified column index.  
Public MethodGetCellHyperlinkGets the effective hyperlink on the cell at the specified index.  
Public MethodGetCellTextOverloaded. Gets the display text in the cell at the specified index.  
Public MethodGetCellValueGets the value of the cell at the specified column index.  
Public MethodGetResolvedCellFormatOverloaded. Gets the resolved cell formatting for the cell at the specified column index.  
Public MethodSetCellCommentSets the comment applied to the cell at the specified column index.  
Public MethodSetCellValueSets the value of a cell at the specified column index.  
Public MethodTryGetCellFormatGets the cell formatting for the cell at the specified column index if it is allocated.  
Public MethodValidateCellValueReturns a boolean indicating if the value of the cell is valid considering its associated DataValidationRule  
See Also

View on GitHub