Excel API Library for Java - Sample Browser | Document Solutions | Create date validation
[
フレーム]
src="bundle.js">
You can validate data entered in date format in cells or a range of cells by applying the date 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[][]{
{new GregorianCalendar(2020, 11, 1), new GregorianCalendar(2020, 11, 14), new GregorianCalendar(2020, 11, 15)},
{new GregorianCalendar(2020, 11, 18), new GregorianCalendar(2020, 11, 19), new GregorianCalendar(2020, 11, 30)},
{new GregorianCalendar(2020, 11, 31), new GregorianCalendar(2019, 11, 13), new GregorianCalendar(2019, 11, 15)},
});
//create date validation.
worksheet.getRange("C2:E4").getValidation().add(ValidationType.Date, ValidationAlertStyle.Stop, ValidationOperator.Between, new GregorianCalendar(2020, 11, 13), new GregorianCalendar(2020, 11, 18));
//set column width just for export shown.
worksheet.getRange("C:E").getEntireColumn().setColumnWidthInPixel(120);
//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("CreateDateValidation.xlsx");
// Create a new workbook
var workbook = Workbook()
val worksheet = workbook.worksheets.get(0)
worksheet.getRange("C2:E4").value = arrayOf(arrayOf
(GregorianCalendar(2020, 11, 1), GregorianCalendar(2020, 11, 14), GregorianCalendar(2020, 11, 15)), arrayOf(GregorianCalendar(2020, 11, 18), GregorianCalendar(2020, 11, 19), GregorianCalendar(2020, 11, 30)), arrayOf(GregorianCalendar(2020, 11, 31), GregorianCalendar(2019, 11, 13), GregorianCalendar(2019, 11, 15)))
//create date validation.
worksheet.getRange("C2:E4").validation.add(ValidationType.Date, ValidationAlertStyle.Stop, ValidationOperator.Between, GregorianCalendar(2020, 11, 13), GregorianCalendar(2020, 11, 18))
//set column width just for export shown.
worksheet.getRange("C:E").entireColumn.columnWidthInPixel = 120.0
//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("CreateDateValidation.xlsx")