//create a new workbook Workbook workbook = new Workbook(); IWorksheet worksheet = workbook.getWorksheets().get(0); worksheet.getRange("C2:E4").setValue(new Object[][]{ {1, 3, 5}, {7, 9, 11}, {13, 15, 17} }); //add whole number validation. worksheet.getRange("C2:E4").getValidation().add(ValidationType.Whole, ValidationAlertStyle.Stop, ValidationOperator.Between, 1, 8); IValidation validation = worksheet.getRange("C2:E4").getValidation(); validation.setIgnoreBlank(true); validation.setInputTitle("Tips"); validation.setInputMessage("Input a value between 1 and 8, please"); validation.setErrorTitle("Error"); validation.setErrorMessage("input value does not between 1 and 8"); validation.setShowInputMessage(true); validation.setShowError(true); //judge if Range["C2:E4"] has validation. for (int i = 1; i <= 3; i++) { for (int j = 2; j <= 4; j++) { if (worksheet.getRange(i, j).getHasValidation()) { //set the range[i, j]'s interior color. worksheet.getRange(i, j).getInterior().setColor(Color.GetLightBlue()); } } } //save to an excel file workbook.save("CreateWholeNumberValidation.xlsx");
//create a new workbook var workbook = Workbook() val worksheet = workbook.worksheets.get(0) worksheet.getRange("C2:E4").value = arrayOf(arrayOf(1, 3, 5), arrayOf(7, 9, 11), arrayOf(13, 15, 17)) //add whole number validation. worksheet.getRange("C2:E4").validation.add(ValidationType.Whole, ValidationAlertStyle.Stop, ValidationOperator.Between, 1, 8) val validation = worksheet.getRange("C2:E4").validation validation.ignoreBlank = true validation.inputTitle = "Tips" validation.inputMessage = "Input a value between 1 and 8, please" validation.errorTitle = "Error" validation.errorMessage = "input value does not between 1 and 8" validation.showInputMessage = true validation.showError = true //judge if Range["C2:E4"] has validation. for (i in 1..3) { for (j in 2..4) { if (worksheet.getRange(i, j).hasValidation) { //set the range[i, j]'s interior color. worksheet.getRange(i, j).interior.color = Color.GetLightBlue() } } } //save to an excel file workbook.save("CreateWholeNumberValidation.xlsx")