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 object at the specific index in the list.
Get_String	Gets the 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.
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.
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.
AddLinkedPicture	Add a linked picture.
AddOleObjectWithLinkedImage	Add a linked picture.
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.
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.
AddSignatureLine	Adds a Signature Line to the worksheet.
GetCount