更新ActiveX组合框控件

可能的使用场景

您可以使用Aspose.Cells读取或写入ActiveX组合框控件的值。请通过Shape.ActiveXControl属性访问ActiveX控件并通过ActiveXControl.Type属性检查其类型,它应返回ControlType.ComboBox值,然后将其强制转换为ComboBoxActiveXControl对象以读取或修改其各种属性。

请下载以下示例代码中使用的示例Excel文件和由其生成的输出Excel文件

更新ActiveX ComboBox控件

下面的屏幕截图显示了示例代码对示例Excel文件的影响。您可以看到,ActiveX组合框的值已更新为"这是组合框控件"。

todo:image_alt_text

示例代码

以下示例代码更新了示例Excel文件中的ActiveX组合框控件的值。

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// The path to the documents directory.
String dataDir = Utils.getSharedDataDir(UpdateActiveXComboBoxControl.class) + "articles/";
// Create a workbook
Workbook wb = new Workbook(dataDir + "sample.xlsx");
// Access first shape from first worksheet
Shape shape = wb.getWorksheets().get(0).getShapes().get(0);
// Access ActiveX ComboBox Control and update its value
if (shape.getActiveXControl() != null) {
// Access Shape ActiveX Control
ActiveXControl c = shape.getActiveXControl();
// Check if ActiveX Control is ComboBox Control
if (c.getType() == ControlType.COMBO_BOX) {
// Type cast ActiveXControl into ComboBoxActiveXControl and
// change its value
ComboBoxActiveXControl comboBoxActiveX = (ComboBoxActiveXControl) c;
comboBoxActiveX.setValue("This is combo box control.");
}
}
// Save the workbook
wb.save(dataDir + "UpdateActiveXComboBoxControl_out.xlsx");