更新ActiveX组合框控件
Contents
[
Hide
]
可能的使用场景
您可以使用Aspose.Cells读取或写入ActiveX组合框控件的值。请通过Shape.ActiveXControl属性访问ActiveX控件并通过ActiveXControl.Type属性检查其类型,它应返回ControlType.ComboBox值,然后将其强制转换为ComboBoxActiveXControl对象以读取或修改其各种属性。
请下载以下示例代码中使用的示例Excel文件和由其生成的输出Excel文件。
更新ActiveX ComboBox控件
下面的屏幕截图显示了示例代码对示例Excel文件的影响。您可以看到,ActiveX组合框的值已更新为"这是组合框控件"。
示例代码
以下示例代码更新了示例Excel文件中的ActiveX组合框控件的值。
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
// 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"); |