- 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.
The Shapes feature is unavailable in applications that use the System.Drawing.Common package v7 and higher in non-Windows environments. The API that uses members from the
System.Drawing.Common package throws the
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.