Version

WorksheetRow Class Methods

For a list of all members of this type, see WorksheetRow members.

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