添加 ActiveX 控件

你可以使用 ShapeCollection.add_active_x_control() 方法与Aspose.Cells for Python via .NET添加ActiveX控件。该方法接受一个参数 ControlType，告诉你需要在工作表中添加的ActiveX控件类型。它具有以下值。

• 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

添加 ActiveX 控件到形状集合后，您可以通过 Shape.active_x_control 属性访问 ActiveX 控件对象，然后设置其各种属性。

以下示例代码使用 Aspose.Cells for Python via .NET 添加切换按钮 ActiveX 控件。

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)