Excel API Library for Java - Sample Browser | Document Solutions | Check Box
[
フレーム]
src="bundle.js">
Refer to the following example code to see how to add check boxes to worksheet. "ICheckBox" represents a control that a user can select (check) or clear (uncheck). A CheckBox can also report its value as indeterminate.
// Create a new workbook
Workbook workbook = new Workbook();
IWorksheet ws = workbook.getWorksheets().get("Sheet1");
ws.getRange("A:A").setColumnWidthInPixel(30d);
ws.getRange("B:B").setColumnWidthInPixel(106d);
// Three check states
ws.getRange("B2").setValue("A checkbox can have 3 check states.");
ICheckBox checkBox1 = ws.getControls().addCheckBox(23.1, 39.6, 88.5, 25.80);
checkBox1.setDisplay3DShading(true);
checkBox1.setIsChecked(false);
ICheckBox checkBox2 = ws.getControls().addCheckBox(23.1, 72, 88.5, 21);
checkBox2.setIsChecked(true);
checkBox2.setText("Checked");
ICheckBox checkBox3 = ws.getControls().addCheckBox(23.1, 101.4, 88.5, 20.39);
checkBox3.setIsChecked(null);
checkBox3.setText("Mixed");
// Data binding
ws.getRange("B11").setValue("It also supports data binding.");
ICheckBox checkBox4 = ws.getControls().addCheckBox(22.5, 175.8, 104.1, 23.39);
checkBox4.setLinkedCell(ws.getRange("D13"));
checkBox4.setIsChecked(true);
// Save to an excel file
workbook.save("CheckBoxesBasicUsage.xlsx");
// Create a new workbook
var workbook = Workbook()
val ws = workbook.worksheets["Sheet1"]
ws.getRange("A:A").columnWidthInPixel = 30.0
ws.getRange("B:B").columnWidthInPixel = 106.0
// Three check states
ws.getRange("B2").value = "A checkbox can have 3 check states."
val checkBox1 = ws.controls.addCheckBox(23.1, 39.6, 88.5, 25.80)
checkBox1.display3DShading = true
checkBox1.isChecked = false
val checkBox2 = ws.controls.addCheckBox(23.1, 72.0, 88.5, 21.0)
checkBox2.isChecked = true
checkBox2.text = "Checked"
val checkBox3 = ws.controls.addCheckBox(23.1, 101.4, 88.5, 20.39)
checkBox3.isChecked = null
checkBox3.text = "Mixed"
// Data binding
ws.getRange("B11").value = "It also supports data binding."
val checkBox4 = ws.controls.addCheckBox(22.5, 175.8, 104.1, 23.39)
checkBox4.linkedCell = ws.getRange("D13")
checkBox4.isChecked = true
// Save to an excel file
workbook.save("CheckBoxesBasicUsage.xlsx")