Spreadsheet 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.