ExcelGroupShapeCollection Class
Represents a collection of ExcelGroupShapes in the worksheet or group.
public class ExcelGroupShapeCollection : ExcelDrawingCollection<ExcelGroupShape>, IList<ExcelGroupShape>, ICollection<ExcelGroupShape>, IEnumerable<ExcelGroupShape>, IEnumerable
Public Class ExcelGroupShapeCollection
Inherits ExcelDrawingCollection(Of ExcelGroupShape)
Implements IList(Of ExcelGroupShape), ICollection(Of ExcelGroupShape), IEnumerable(Of ExcelGroupShape), IEnumerable
- Inheritance:
- System.ObjectExcelGroupShapeCollection
Implements
Methods
Add(AnchorCell, AnchorCell)
Adds a new group shape to the collection which moves and sizes with cells.
public ExcelGroupShape Add(AnchorCell positionFrom, AnchorCell positionTo)
Public Function Add(positionFrom As AnchorCell, positionTo As AnchorCell) As ExcelGroupShape
Parameters
positionFrom
- AnchorCell
The group shape's position (top-left corner).
positionTo
- AnchorCell
The group shape's end position (bottom-right corner).
Returns
A new group shape added to the collection which moves and sizes with cells.
Add(AnchorCell, Double, Double, LengthUnit)
Adds a new group shape to the collection which moves but doesn't size with cells.
public ExcelGroupShape Add(AnchorCell positionFrom, double width, double height, LengthUnit unit)
Public Function Add(positionFrom As AnchorCell, width As Double, height As Double, unit As LengthUnit) As ExcelGroupShape
Parameters
positionFrom
- AnchorCell
The group shape's position.
width
- System.Double
The group shape's width.
height
- System.Double
The group shape's height.
unit
- LengthUnit
The length unit in which all length parameters are specified.
Returns
A new group shape added to the collection which moves but doesn't size with cells.
Add(Double, Double, Double, Double, LengthUnit)
Adds a new group shape to the collection which doesn't move nor sizes with cells.
public ExcelGroupShape Add(double left, double top, double width, double height, LengthUnit unit)
Public Function Add(left As Double, top As Double, width As Double, height As Double, unit As LengthUnit) As ExcelGroupShape
Parameters
left
- System.Double
The distance of the left edge of the group shape from the left edge of the worksheet or group.
top
- System.Double
The distance of the top edge of the group shape from the top edge of the worksheet or group.
width
- System.Double
The group shape's width.
height
- System.Double
The group shape's height.
unit
- LengthUnit
The length unit in which all length parameters are specified.
Returns
A new group shape added to the collection which doesn't move nor sizes with cells.
Add(String, Double, Double, LengthUnit)
Adds a new group shape to the collection which moves but doesn't size with cells.
public ExcelGroupShape Add(string positionFromCell, double width, double height, LengthUnit unit)
Public Function Add(positionFromCell As String, width As Double, height As Double, unit As LengthUnit) As ExcelGroupShape
Parameters
positionFromCell
- System.String
The group shape's position (for example, "A1").
width
- System.Double
The group shape's width.
height
- System.Double
The group shape's height.
unit
- LengthUnit
The length unit in which all length parameters are specified.
Returns
A new group shape added to the collection which moves but doesn't size with cells.
Add(String, String)
Adds a new group shape to the collection which moves and sizes with cells.
public ExcelGroupShape Add(string positionFromCell, string positionToCell)
Public Function Add(positionFromCell As String, positionToCell As String) As ExcelGroupShape
Parameters
positionFromCell
- System.String
The group shape's position (top-left corner) (for example, "A1").
positionToCell
- System.String
The group shape's end position (bottom-right corner) (for example, "B2").
Returns
A new group shape added to the collection which moves and sizes with cells.