//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); ComboBoxCellType cellType = new ComboBoxCellType(); cellType.setEditorValueType(EditorValueType.Value); ComboBoxCellItem item = new ComboBoxCellItem(); item.setValue("US"); item.setText("United States"); cellType.getItems().add(item); item = new ComboBoxCellItem(); item.setValue("CN"); item.setText("China"); cellType.getItems().add(item); item = new ComboBoxCellItem(); item.setValue("JP"); item.setText("Japan"); cellType.getItems().add(item); worksheet.getRange("C5").setCellType(cellType); worksheet.getRange("C5").setValue("CN"); //save to an excel file workbook.save("AddComboBoxCellType.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) val cellType = ComboBoxCellType() cellType.editorValueType = EditorValueType.Value var item = ComboBoxCellItem() item.setValue("US") item.setText("United States") cellType.items.add(item) item = ComboBoxCellItem() item.setValue("CN") item.setText("China") cellType.items.add(item) item = ComboBoxCellItem() item.setValue("JP") item.setText("Japan") cellType.items.add(item) worksheet.getRange("C5").cellType = cellType worksheet.getRange("C5").setValue("CN") //save to an excel file workbook.save("AddComboBoxCellType.xlsx")