Add ActiveX Controls

You can add ActiveX controls with Aspose.Cells for Python via .NET using the ShapeCollection.add_active_x_control() method. This method takes a parameter ControlType which tells what type of ActiveX control needs to be added inside a worksheet. It has the following values.

• ControlType.COMMAND_BUTTON
• ControlType.COMBO_BOX
• ControlType.CHECK_BOX
• ControlType.LIST_BOX
• ControlType.TEXT_BOX
• ControlType.SPIN_BUTTON
• ControlType.RADIO_BUTTON
• ControlType.LABEL
• ControlType.IMAGE
• ControlType.TOGGLE_BUTTON
• ControlType.SCROLL_BAR
• ControlType.BAR_CODE
• ControlType.UNKNOWN

Once, you have added the ActiveX control inside the shape collection, you can then access the ActiveX control object via Shape.active_x_control property and then set its various properties.

The following sample code adds Toggle Button ActiveX Control using Aspose.Cells for Python via .NET.

from aspose.cells import SaveFormat, Workbook
from aspose.cells.drawing.activexcontrols import ControlType

#  For complete examples and data files, please go to https:# github.com/aspose-cells/Aspose.Cells-for-.NET
#  The path to the documents directory.
dataDir = RunExamples.GetDataDir(".")
#  Create workbook object
wb = Workbook()
#  Access first worksheet
sheet = wb.worksheets[0]
#  Add Toggle Button ActiveX Control inside the Shape Collection
s = sheet.shapes.add_active_x_control(ControlType.TOGGLE_BUTTON, 4, 0, 4, 0, 100, 30)
#  Access the ActiveX control object and set its linked cell property
c = s.active_x_control
c.linked_cell = "A1"
#  Save the worbook in xlsx format
wb.save(dataDir + "AddActiveXControls_out.xlsx", SaveFormat.XLSX)