ExcelShape Class

Namespace:

GemBox.Spreadsheet

Assembly:

GemBox.Spreadsheet.dll

Represents a drawing that has a specific shape / geometry.

• C#
• VB.NET

public sealed class ExcelShape : ExcelDrawing

Public NotInheritable Class ExcelShape
    Inherits ExcelDrawing

Inheritance:

Object

ExcelDrawing

ExcelShape

Properties

AdjustValues

Gets the shape's adjust values.

• C#
• VB.NET

public IDictionary<string, double> AdjustValues { get; }

Public ReadOnly Property AdjustValues As IDictionary(Of String, Double)

Property Value

IDictionary<String, Double>

The shape's adjust values.

Remarks

Adjust value is a varying parameter used in calculation of shape's geometry which is specified using Drawing ML.

Each ShapeType defines its own set of adjust values (and some/most do not have any).

Fill

Gets or sets the fill formating options.

• C#
• VB.NET

public FillFormat Fill { get; set; }

Public Property Fill As FillFormat

Property Value

FillFormat

The fill formatting options.

FlipHorizontal

Gets or sets a value indicating whether to flip the drawing horizontally - reflect it across a vertical line that intersects the center of the drawing's bounding box.

• C#
• VB.NET

public bool FlipHorizontal { get; set; }

Public Property FlipHorizontal As Boolean

Property Value

Boolean

true to flip the drawing horizontally; otherwise, false.

Remarks

This property is supported only when loading and saving to XLSX file format.

FlipVertical

Gets or sets a value indicating whether to flip the drawing vertically - reflect it across a horizontal line that intersects the center of the drawing's bounding box.

• C#
• VB.NET

public bool FlipVertical { get; set; }

Public Property FlipVertical As Boolean

Property Value

Boolean

true to flip the drawing horizontally; otherwise, false.

Remarks

This property is supported only when loading and saving to XLSX file format.

Outline

Gets or sets the outline formating options.

• C#
• VB.NET

public LineFormat Outline { get; set; }

Public Property Outline As LineFormat

Property Value

LineFormat

The outline formatting options.

Rotation

Gets or sets the amount (in degrees) by which the drawing is rotated clockwise about the center of the drawing's bounding box.

• C#
• VB.NET

public double Rotation { get; set; }

Public Property Rotation As Double

Property Value

Double

The amount (in degrees) by which the drawing is rotated clockwise about the center of the drawing's bounding box.

Remarks

This property is supported only when loading and saving to XLSX file format.

ShapeType

Gets or sets the type of the shape (geometry).

• C#
• VB.NET

public ShapeType ShapeType { get; }

Public ReadOnly Property ShapeType As ShapeType

Property Value

ShapeType

The type of the shape (geometry).

Text

Gets the text content and formatting associated with this ExcelShape.

• C#
• VB.NET

public TextBox Text { get; }

Public ReadOnly Property Text As TextBox

Property Value

TextBox

The text content and formatting associated with this ExcelShape.

Inherited Properties

Hyperlink	Gets or sets the hyperlink on this drawing (picture, chart, etc.). (Inherited from ExcelDrawing)
Metadata	Gets the metadata (non-visual properties) of this ExcelDrawing instance. (Inherited from ExcelDrawing)
Position	Gets the position of this drawing (picture, chart, etc.) in the worksheet. (Inherited from ExcelDrawing)
Worksheet	Gets the parent worksheet. (Inherited from ExcelDrawing)

Inherited Methods

Format()	Formats this drawing (picture, chart, etc.) to its default size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing)
Format(Double, Double, LengthUnit)	Formats this drawing (picture, chart, etc.) to specified size so it can be exported to PDF, XPS, image or be printed. (Inherited from ExcelDrawing)