Excel API Library for Java - Sample Browser | Document Solutions | Create decimal validation
[
フレーム]
src="bundle.js">
You can validate your data and ensure users add only decimal numbers in cells or a range of cells by applying the decimal validation in a worksheet.
// Create a new workbook
Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.getWorksheets().get(0);
worksheet.getRange("C2:E4").setValue(new Object[][]{
{1, 3.0, 3.4},
{7, 9, 102.7},
{102.8, 110, 120}
});
//add decimal validation.
worksheet.getRange("C2:E4").getValidation().add(ValidationType.Decimal, ValidationAlertStyle.Stop, ValidationOperator.Between, 3.4, 102.8);
IValidation validation = worksheet.getRange("C2:E4").getValidation();
validation.setIgnoreBlank(true);
validation.setInputTitle("Tips");
validation.setInputMessage("Input a decimal value between 3.4 and 102.8, please.");
validation.setErrorTitle("Error");
validation.setErrorMessage("input value does not between 3.4 and 102.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("CreateDecimalValidation.xlsx");
// Create a new workbook
var workbook = Workbook()
val worksheet = workbook.worksheets.get(0)
worksheet.getRange("C2:E4").value = arrayOf(arrayOf(1, 3.0, 3.4), arrayOf(7, 9, 102.7), arrayOf(102.8, 110, 120))
//add decimal validation.
worksheet.getRange("C2:E4").validation.add(ValidationType.Decimal, ValidationAlertStyle.Stop, ValidationOperator.Between, 3.4, 102.8)
val validation = worksheet.getRange("C2:E4").validation
validation.ignoreBlank = true
validation.inputTitle = "Tips"
validation.inputMessage = "Input a decimal value between 3.4 and 102.8, please."
validation.errorTitle = "Error"
validation.errorMessage = "input value does not between 3.4 and 102.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("CreateDecimalValidation.xlsx")