Sets the value of a cell at the specified column index. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow.value The value to assign to the cell. Exceptions Exception Description System.ArgumentOutOfRangeException columnIndex is less than zero or greater than or equal to the number...
Gets the cell formatting for the cell at the specified column index if it is allocated. Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow.cellFormat [Out] The cell formatting for the cell at the specified column index if it is allocated; null otherwise. Return Value True if the ce...
Gets the cell formatting for the cell at the specified column index if it is allocated. Overload List
Returns a boolean indicating if the value of the cell is valid considering its associated DataValidationRule Syntax Parameters columnIndex The 0-based index of the cell within the WorksheetRow. Return Value Returns false if the cell has an associated DataValidationRule and the current Value does not pass the valid...
Abstract base class for all shapes (atomic or compound) in a worksheet. Syntax Remarks Atomic shapes are singular shape entities, such as an image, a polygon, or text. Compound shapes are groupings of shapes, and are represented by WorksheetShapeGroup instances. Currently, not all shape information is customizable...
A collection of WorksheetShape instances in a Worksheet or WorksheetShapeGroup. Syntax
Public Properties Public Methods
Public Methods
Public Properties
Adds a predefined shape to the collection with the specified bounds. Syntax Parameters shapeType The type of shape to add to the collection.boundsInTwips The bounds of the shape on the Worksheet in twips (1/20th of a point). Return Value A WorksheetShape-derived instance representing the predefined shape. Exceptio...