// Create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); CheckBoxCellType cellType = new CheckBoxCellType(); cellType.setCaption("Caption"); cellType.setTextTrue("sample1"); cellType.setTextFalse("sample1"); cellType.setTextIndeterminate("sample1"); cellType.setIsThreeState(true); cellType.setTextAlign(CheckBoxAlign.Right); CheckBoxCellType cellType2 = new CheckBoxCellType(); cellType2.setCaption("Caption"); cellType2.setTextTrue("sample2"); cellType2.setTextFalse("sample2"); cellType2.setTextIndeterminate("sample2"); cellType2.setIsThreeState(true); cellType2.setTextAlign(CheckBoxAlign.Right); cellType2.setBoxSize(15); CheckBoxCellType cellType3 = new CheckBoxCellType(); cellType3.setCaption("Caption"); cellType3.setTextTrue("sample3"); cellType3.setTextFalse("sample3"); cellType3.setTextIndeterminate("sample3"); cellType3.setIsThreeState(true); cellType3.setTextAlign(CheckBoxAlign.Right); cellType3.setBoxSize(18); worksheet.getRange("A1").setCellType(cellType); worksheet.getRange("A2").setCellType(cellType2); worksheet.getRange("A3").setCellType(cellType3); worksheet.getRange("A1:A3").setValue(false); worksheet.getRange("1:3").getEntireRow().setRowHeight(20); worksheet.getRange("A:A").setColumnWidth(15); worksheet.getRange("A:A").setHorizontalAlignment(HorizontalAlignment.Center); // Save to a pdf file workbook.save("SizeOfCheckBox.pdf");
// Create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets[0] val cellType = CheckBoxCellType() cellType.caption = "Caption" cellType.textTrue = "sample1" cellType.textFalse = "sample1" cellType.textIndeterminate = "sample1" cellType.isThreeState = true cellType.textAlign = CheckBoxAlign.Right val cellType2 = CheckBoxCellType() cellType2.caption = "Caption" cellType2.textTrue = "sample2" cellType2.textFalse = "sample2" cellType2.textIndeterminate = "sample2" cellType2.isThreeState = true cellType2.textAlign = CheckBoxAlign.Right cellType2.setBoxSize(15) val cellType3 = CheckBoxCellType() cellType3.caption = "Caption" cellType3.textTrue = "sample3" cellType3.textFalse = "sample3" cellType3.textIndeterminate = "sample3" cellType3.isThreeState = true cellType3.textAlign = CheckBoxAlign.Right cellType3.setBoxSize(18) worksheet.getRange("A1").cellType = cellType worksheet.getRange("A2").cellType = cellType2 worksheet.getRange("A3").cellType = cellType3 worksheet.getRange("A1:A3").value = false worksheet.getRange("1:3").entireRow.rowHeight = 20.0 worksheet.getRange("A:A").columnWidth = 15.0 worksheet.getRange("A:A").horizontalAlignment = HorizontalAlignment.Center // Save to a pdf file workbook.save("SizeOfCheckBox.pdf")