Gets the WorksheetTableStyle at the specified index. Overload List Exceptions Exception Description System.ArgumentOutOfRangeException index is less than 0 or greater than or equal to Count.
Represents the various way to combine a cells value and format string to get its text. Syntax Members Member Description AsDisplayed Format the cell text as it is displayed in the Microsoft Excel UI. This takes into account the cell width when formatting the text. IgnoreCellWidth Format the cell text as if it had ...
Represents the various operators which can be used when validating the cell value against two constraints. Syntax Members Member Description Between Only allows the cell value if it or its text length, depending on the validation criteria, is between the constraints applied to the validation rule. The constraints ...
Represents a data validation rule which can validate the cell value against two constraint values or formulas. Syntax
Public Constructors Public Properties Public Methods
Public Methods
Public Properties
Gets the lower constraint formula used to validate the cell value. Syntax Parameters address The address of the cell or region that serves as the basis for relative references, or null to use the top-left cell of the worksheet. Return Value A formula used to validate the value applied to a cell. Exceptions Excepti...
Gets the lower constraint formula used to validate the cell value. Syntax Parameters address The address of the cell or region that serves as the basis for relative references, or null to use the top-left cell of the worksheet.format The workbook format with which to parse address.cellReferenceMode The cell refere...
Gets the lower constraint formula used to validate the cell value. Overload List