Static $tStatic nextGets the number of shapes in the collection. The number of shapes in the collection.
Adds a predefined shape to the collection with the specified bounds.
ArgumentNullException 'sheet' is null.
InvalidEnumArgumentException 'shapeType' is not defined in the PredefinedShapeType enumeration.
A WorksheetShape-derived instance representing the predefined shape.
The type of shape to add to the collection.
The sheet to which the 'boundsInTwips' relate.
The bounds of the shape on the 'sheet' in twips (1/20th of a point).
Adds a predefined shape to the collection with the specified anchors.
InvalidEnumArgumentException 'shapeType' is not defined in the PredefinedShapeType enumeration.
InvalidOperationException 'topLeftCornerCell' or 'bottomRightCornerCell' is null.
InvalidOperationException 'topLeftCornerCell' and 'bottomRightCornerCell' belong to different worksheets or a worksheet other than the worksheet to which this collection belongs.
A WorksheetShape-derived instance representing the predefined shape.
The type of shape to add to the collection.
The cell where the top-left corner of the shape resides.
The position in the 'topLeftCornerCell' of the shape's top-left corner, expressed in percentages.
The cell where the bottom-right corner of the shape resides.
the position in the 'bottomRightCornerCell' of the shape's bottom-right corner, expressed in percentages.
Adds a predefined shape to the collection with the specified bounds.
InvalidOperationException This shapes collection belongs to a WorksheetShapeGroup which isn't placed on a Worksheet yet. In this case, call add instead and specify the Worksheet where the group will be added.
InvalidEnumArgumentException 'shapeType' is not defined in the PredefinedShapeType enumeration.
A WorksheetShape-derived instance representing the predefined shape.
The type of shape to add to the collection.
The bounds of the shape on the Worksheet in twips (1/20th of a point).
Adds a shape to the collection.
ArgumentNullException 'shape' is null.
InvalidOperationException 'shape' has already been added to a worksheet or group.
InvalidOperationException 'shape' does not have the WorksheetShape.topLeftCornerCell or WorksheetShape.bottomRightCornerCell set.
InvalidOperationException Adding 'shape' to this collection will place it on a different worksheet then either its TopLeftCornerCell or BottomRightCornerCell or 'shape' is a WorksheetShapeGroup and adding it to this collection will create a similar situation for one of its descendant shapes.
InvalidOperationException 'shape' is a WorksheetShapeGroup and this is the group's collection of shapes.
The shape to add to the collection.
Adds a chart to the collection with the specified bounds.
ArgumentNullException if sheet is null.
InvalidEnumArgumentException 'chartType' is not defined in the ChartType enumeration.
InvalidOperationException if a chart is being added to the Shapes collection of another Chart is null.
InvalidOperationException if a
A WorksheetChart-instance.
The type of chart to add to the collection.
The sheet to which the 'boundsInTwips' relate.
The bounds of the shape on the 'sheet' in twips (1/20th of a point).
An optional callback for initializing the chart before it is added to the collection.
Adds a chart to the collection with the specified bounds.
InvalidEnumArgumentException 'chartType' is not defined in the ChartType enumeration.
InvalidOperationException 'topLeftCornerCell' or 'bottomRightCornerCell' is null.
InvalidOperationException 'topLeftCornerCell' and 'bottomRightCornerCell' belong to different worksheets or a worksheet other than the worksheet to which this collection belongs.
InvalidOperationException if a chart is being added to the Shapes collection of another Chart is null.
InvalidOperationException if a
A WorksheetChart-instance.
The type of chart to add to the collection.
The cell where the top-left corner of the shape resides.
The position in the 'topLeftCornerCell' of the shape's top-left corner, expressed in percentages.
The cell where the bottom-right corner of the shape resides.
the position in the 'bottomRightCornerCell' of the shape's bottom-right corner, expressed in percentages.
An optional callback for initializing the chart before it is added to the collection.
Adds a chart to the collection with the specified bounds.
ArgumentNullException if worksheet is null.
InvalidEnumArgumentException 'chartType' is not defined in the ChartType enumeration.
InvalidOperationException if a chart is being added to the Shapes collection of another Chart is null.
InvalidOperationException if a
A WorksheetChart-instance.
The type of chart to add to the collection.
The bounds of the shape on the worksheet in twips (1/20th of a point).
An optional callback for initializing the chart before it is added to the collection.
Determines whether a shape is in the collection.
True if the shape is found; False otherwise.
The shape to locate in the collection.
Gets the shape at the specified index in the collection. The shape at the specified index.
ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.
Removes the shape at the specified index from the collection.
ArgumentOutOfRangeException 'index' is less than zero or 'index' is greater than or equal to count.
The index of the shape to remove from the collection.
Removes the specified shape from the collection.
True if the shape was successfully removed from the collection; False if the shape did not exist in the collection.
The shape to remove from the collection.
Static compareStatic compareStatic equalsStatic equalsStatic getStatic getStatic getStatic referenceStatic static
A collection of WorksheetShape instances in a Worksheet or WorksheetShapeGroup. @see@see