Gets the effective hyperlink on the cell. Syntax Remarks If multiple hyperlinks are applied to the cell, the last one in the Worksheet.Hyperlinks collection will be used. If the cell has one or more hyperlinks in the Worksheet.Hyperlinks collection as well as a formula containing a HYPERLINK function, the last hyp...
Gets the resolved cell formatting for this cell. Syntax Return Value A format object describing the actual formatting that will be used when displayed this cell in Microsoft Excel. Remarks If any cell format properties are the default values on the cell, the values from the owning rows cell format will be used. If...
Gets the text displayed in the cell. Syntax Remarks The display text is based on the value of the cell and the format string applied to the cell. Note: it is slightly faster to use the WorksheetRow.GetCellText method, which does not create a WorksheetCell instance internally. However, if a reference to the Workshe...
Gets the text of the cell. Syntax Parameters textFormatMode The format mode to use when getting the cell text. Exceptions Exception Description System.ComponentModel.InvalidEnumArgumentException textFormatMode is not defined in the TextFormatMode enumeration. Remarks The text is based on the value of the cell and ...
Gets the text displayed in the cell. Overload List
Gets the value which indicates whether the cells format has been initialized yet. Syntax
Get the value indicating whether the cell has an associated comment. Syntax Property Value True if the cell has an associated comment; False otherwise. Remarks Note: it is slightly faster to use the WorksheetRow.GetCellComment method and check for a non null return value, which does not create a WorksheetCell inst...
Returns True if a particular type of value can be exported to excel. Syntax Parameters cellType The type to test. Return Value True if the type is supported as a cell value, False otherwise. Exceptions Exception Description System.ArgumentNullException cellType is null.
Determines whether two cell instances are equivalent. Syntax Parameters a b Return Value True if the cells refer to the same location on the same worksheet; False otherwise.
Determines whether two cell instances are not equivalent. Syntax Parameters a b Return Value False if the cells refer to the same location on the same worksheet; True otherwise.