ShapeCollection Class

ShapeCollection class

Represents all the shape in a worksheet/chart.

type ShapeCollection struct  {
	ptr unsafe.Pointer
}

Constructors

Method	Description

Methods

Method	Description
IsNull	Checks whether the implementation object is nullptr.
Get_Int	Gets the Shape object at the specific index in the list.
Get_String	Gets the Shape object by the name of the shape.
AddCopy	Adds and copy a shape to the worksheet.
AddCheckBox	Adds a checkbox to the worksheet.
AddTextBox	Adds a text box to the worksheet.
AddEquation	Add an equation object to the worksheet.
AddSpinner	Adds a Spinner to the worksheet.
AddScrollBar	Adds a ScrollBar to the worksheet.
AddRadioButton	Adds a RadioButton to the worksheet.
AddListBox	Adds a ListBox to the worksheet.
AddComboBox	Adds a ComboBox to the worksheet.
AddGroupBox	Adds a GroupBox to the worksheet.
AddButton	Adds a Button to the worksheet.
AddLabel	Adds a Label to the worksheet.
AddLabelInChart	Adds a label to the chart.
AddTextBoxInChart	Adds a textbox to the chart.
AddTextEffectInChart	Inserts a WordArt object to the chart
AddTextEffect	Inserts a WordArt object.
AddWordArt	Adds preset WordArt since Excel 2007.s
AddRectangle	Adds a RectangleShape to the worksheet.
AddOval	Adds a Oval to the worksheet.
AddLine	Adds a LineShape to the worksheet.
AddFreeFloatingShape	Adds a free floating shape to the worksheet.Only applies for line/image shape.
AddShapeInChart_MsoDrawingType_PlacementType_Int_Int_Int_Int_Stream	Add a shape to chart .All unit is 1/4000 of chart area.
AddShapeInChart_MsoDrawingType_PlacementType_Int_Int_Int_Int	Add a shape to chart .All unit is 1/4000 of chart area.
AddShapeInChartByScale_MsoDrawingType_PlacementType_Double_Double_Double_Double	Add a shape to chart. All unit is percent scale of chart area.
AddShapeInChartByScale_MsoDrawingType_PlacementType_Double_Double_Double_Double_Stream	Add a shape to chart .All unit is 1/4000 of chart area.
AddArc	Adds a ArcShape to the worksheet.
AddShape	Adds a Shape to the worksheet.
AddAutoShape	Adds a AutoShape to the worksheet.
AddAutoShapeInChart	Adds a AutoShape to the chart.
AddActiveXControl	Creates an Activex Control.
AddPicture_Int_Int_Int_Int_Stream	Adds a picture to the collection.
AddPicture_Int_Int_Stream_Int_Int	Adds a picture to the collection.
AddSvg	Adds svg image.
AddIcons	Adds svg image.
AddLinkedPicture	Add a linked picture.
AddOleObjectWithLinkedImage	Add a linked picture.
AddPictureInChart	Adds a picture to the chart.
AddOleObject	Adds an OleObject.
CopyCommentsInRange	Copy all comments in the range.
CopyInRange	Copy shapes in the range to destination range.
DeleteInRange	Delete shapes in the range.Comment shapes will not be deleted.
DeleteShape	Delete a shape. If the shape is in the group or is a comment shape, it will not be deleted.
Group	Group the shapes.
Ungroup	Ungroups the shape items.
RemoveAt	Remove the shape.
Remove	Remove the shape.
Clear	Clear all shapes in the worksheet.
UpdateSelectedValue	Update the selected value by the value of the linked cell or range of the shape.
AddFreeform	Adds a freeform shape to the worksheet.
AddSignatureLine	Adds a Signature Line to the worksheet.
GetCount