Version

WorksheetCell Class Members

The following tables list the members exposed by WorksheetCell.

Public Properties
 NameDescription
Public PropertyAssociatedDataTableGets the data table to which the cell belongs.  
Public PropertyAssociatedMergedCellsRegionGets the merged cells region which contains the cell, or null if the cell is not merged.  
Public PropertyAssociatedTableGets the WorksheetTable to which this cell belongs.  
Public PropertyCellFormatGets the cell formatting for this cell.  
Public PropertyColumnIndexGets the column index of the cell.  
Public PropertyCommentGets or sets the comment applied to the cell.  
Public PropertyDataValidationRuleGets or sets the data validation rule for the WorksheetCell.  
Public PropertyFormulaGets the formula which has been applied to the cell.  
Public PropertyHasCellFormatGets the value which indicates whether the cell's format has been initialized yet.  
Public PropertyHasCommentGet the value indicating whether the cell has an associated comment.  
Public PropertyRowIndexGets the row index of the cell.  
Public PropertyValueGets or sets the value of the cell.  
Public PropertyWorksheetGets the worksheet to which the cell belongs.  
Public Methods
 NameDescription
Public MethodApplyFormulaApplies a formula to the cell.  
Public MethodEqualsDetermines whether the specified object is another WorksheetCell instance which refers to the same location on the same worksheet as this cell.  
Public MethodGetBoundsInTwipsOverloaded. Gets the bounds of the cell in twips (1/20th of a point).  
Public Methodstatic (Shared in Visual Basic)GetCellAddressStringOverloaded. Gets the string representation of the address of the cell.  
Public MethodGetHashCodeGets the hash code of the WorksheetCell.  
Public MethodGetHyperlinkGets the effective hyperlink on the cell.  
Public MethodGetResolvedCellFormatGets the resolved cell formatting for this cell.  
Public MethodGetTextOverloaded. Gets the text displayed in the cell.  
Public Methodstatic (Shared in Visual Basic)IsCellTypeSupportedReturns True if a particular type of value can be exported to excel.  
Public MethodToStringOverloaded. Gets the string representation of the address of the cell.  
Public MethodValidateValueReturns a boolean indicating if the value of the cell is valid considering the associated DataValidationRule  
Public Operators
public Operator Equality Determines whether two cell instances are equivalent.
public Operator Inequality Determines whether two cell instances are not equivalent.
See Also

View on GitHub