Shapes
- 2 minutes to read
The Spreadsheet Document API library allows you to add shapes to a worksheet, adjust their fill and outline settings, connect and group shapes, create a shape text, or remove shapes from a document. You can print and export documents that contain shapes to PDF/HTML. All shape types are supported: from simple lines and rectangles, to 3-D shapes with advanced effects.
Shape API
An individual shape (Shape) is a member of the Worksheet.Shapes collection. The ShapeCollection collection stores all drawing objects embedded in a worksheet (shapes, pictures, and charts). You can access an existing shape by its index in the shape collection or using the ShapeCollection.GetShapeById method. The Shape.ShapeType property allows you to distinguish between different drawing object types within a worksheet.
The ShapeCollection and Shape interfaces provide methods and properties designed to manipulate shapes in a document.
Member | Description | Example |
|---|---|---|
Creates a shape. | ||
Creates a text box. | ||
Specifies a shape’s geometry. | ||
Creates a group of shapes. | ||
Splits a shape group into individual shapes. | ||
Creates a connector. | ||
Provides access to connector settings. | ||
Provides access to a shape’s text format settings. | ||
Allows you to add text to a shape and specify its font characteristics and paragraph properties. | ||
Provides access to a shape’s fill options. | ||
Provides access to options used to format a shape’s outline. | ||
Removes a shape from a worksheet. |