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.
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.
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.
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
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
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
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.
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 specified shape from 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