A collection of instances in a or .

Inheritance

Implements
  • ICollection<WorksheetShape>
  • IEnumerable<WorksheetShape>
  • IEnumerable

Gets the number of shapes in the collection.

public int Count { get; }

Gets the shape at the specified index in the collection.

public WorksheetShape this[int index] { get; }

Adds a predefined shape to the collection with the specified bounds.

public WorksheetShape Add(PredefinedShapeType shapeType, Rect boundsInTwips)

Parameters

  • shapeType: PredefinedShapeType
  • boundsInTwips: Rect

Returns any

Add(PredefinedShapeType, Sheet, Rect)

Section titled "Add(PredefinedShapeType, Sheet, Rect)"

Adds a predefined shape to the collection with the specified bounds.

public WorksheetShape Add(PredefinedShapeType shapeType, Sheet sheet, Rect boundsInTwips)

Parameters

  • shapeType: PredefinedShapeType
  • sheet: Sheet
  • boundsInTwips: Rect

Returns any

Add(PredefinedShapeType, WorksheetCell, Point, WorksheetCell, Point)

Section titled "Add(PredefinedShapeType, WorksheetCell, Point, WorksheetCell, Point)"

Adds a predefined shape to the collection with the specified anchors.

public WorksheetShape Add(PredefinedShapeType shapeType, WorksheetCell topLeftCornerCell, Point topLeftCornerPosition, WorksheetCell bottomRightCornerCell, Point bottomRightCornerPosition)

Parameters

  • shapeType: PredefinedShapeType
  • topLeftCornerCell: WorksheetCell
  • topLeftCornerPosition: Point
  • bottomRightCornerCell: WorksheetCell
  • bottomRightCornerPosition: Point

Returns any

Adds a shape to the collection.

public void Add(WorksheetShape shape)

Parameters

  • shape: WorksheetShape

Returns any

AddChart(ChartType, Rect, Action<WorksheetChart>)

Section titled "AddChart(ChartType, Rect, Action<WorksheetChart>)"

Adds a chart to the collection with the specified bounds.

public WorksheetChart AddChart(ChartType chartType, Rect boundsInTwips, Action<WorksheetChart> chartInitializer = null)

Parameters

  • chartType: ChartType
  • boundsInTwips: Rect
  • chartInitializer: Action

Returns any

AddChart(ChartType, Sheet, Rect, Action<WorksheetChart>)

Section titled "AddChart(ChartType, Sheet, Rect, Action<WorksheetChart>)"

Adds a chart to the collection with the specified bounds.

public WorksheetChart AddChart(ChartType chartType, Sheet sheet, Rect boundsInTwips, Action<WorksheetChart> chartInitializer = null)

Parameters

  • chartType: ChartType
  • sheet: Sheet
  • boundsInTwips: Rect
  • chartInitializer: Action

Returns any

AddChart(ChartType, WorksheetCell, Point, WorksheetCell, Point, Action<WorksheetChart>)

Section titled "AddChart(ChartType, WorksheetCell, Point, WorksheetCell, Point, Action<WorksheetChart>)"

Adds a chart to the collection with the specified bounds.

public WorksheetChart AddChart(ChartType chartType, WorksheetCell topLeftCornerCell, Point topLeftCornerPosition, WorksheetCell bottomRightCornerCell, Point bottomRightCornerPosition, Action<WorksheetChart> chartInitializer = null)

Parameters

  • chartType: ChartType
  • topLeftCornerCell: WorksheetCell
  • topLeftCornerPosition: Point
  • bottomRightCornerCell: WorksheetCell
  • bottomRightCornerPosition: Point
  • chartInitializer: Action

Returns any

Clears all shapes from the collection.

public void Clear()

Returns any

Determines whether a shape is in the collection.

public bool Contains(WorksheetShape shape)

Parameters

  • shape: WorksheetShape

Returns any

Removes the specified shape from the collection.

public bool Remove(WorksheetShape shape)

Parameters

  • shape: WorksheetShape

Returns any

Removes the shape at the specified index from the collection.

public void RemoveAt(int index)

Parameters

  • index: int

Returns any