How to: Remove a Shape

• Jun 07, 2019

This example illustrates how to remove a shape.

You can remove an item from the ShapeCollection using the ShapeCollection.RemoveAt method.

C#

 worksheet.Shapes.RemoveAt(3);

VB.NET

 worksheet.Shapes.RemoveAt(3)

If a target item is a Chart or Picture object, the ShapeCollection.RemoveAt method call removes this shape from two collections: ShapeCollection and ChartCollection or PictureCollection, respectively.

Call the Shape.Delete method to remove a Shape object directly. The code sample below shows how to remove all connectors from a worksheet:

C#

 foreach (Shape shape in worksheet.Shapes)
{
    if (shape.ShapeType == ShapeType.Connector)
        shape.Delete();
}

VB.NET

 For Each shape As Shape In worksheet.Shapes
    If shape.ShapeType = ShapeType.Connector Then shape.Delete()
Next