Excel API Library for Java - Sample Browser | Document Solutions | Create time validation
[
フレーム]
src="bundle.js">
You can validate the time entered in cells or a range of cells by applying the time 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(1899, 11, 30, 13, 0, 0), new GregorianCalendar(1899, 11, 30, 13, 29, 59), new GregorianCalendar(1899, 11, 30, 13, 30, 0)},
{new GregorianCalendar(1899, 11, 30, 14, 0, 0), new GregorianCalendar(1899, 11, 30, 15, 0, 0), new GregorianCalendar(1899, 11, 30, 16, 30, 0)},
{new GregorianCalendar(1899, 11, 30, 19, 0, 0), new GregorianCalendar(1899, 11, 30, 18, 29, 59), new GregorianCalendar(1899, 11, 30, 18, 30, 0)}
});
//create time validation.
worksheet.getRange("C2:E4").getValidation().add(ValidationType.Time, ValidationAlertStyle.Stop, ValidationOperator.Between, new GregorianCalendar(1899, 11, 30, 13, 30, 0), new GregorianCalendar(1899, 11, 30, 18, 30, 0));
//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("CreateTimeValidation.xlsx");
// Create a new workbook
var workbook = Workbook()
val worksheet = workbook.worksheets.get(0)
worksheet.getRange("C2:E4").value = arrayOf(arrayOf
(GregorianCalendar(1899, 11, 30, 13, 0, 0), GregorianCalendar(1899, 11, 30, 13, 29, 59), GregorianCalendar(1899, 11, 30, 13, 30, 0)), arrayOf(GregorianCalendar(1899, 11, 30, 14, 0, 0), GregorianCalendar(1899, 11, 30, 15, 0, 0), GregorianCalendar(1899, 11, 30, 16, 30, 0)), arrayOf(GregorianCalendar(1899, 11, 30, 19, 0, 0), GregorianCalendar(1899, 11, 30, 18, 29, 59), GregorianCalendar(1899, 11, 30, 18, 30, 0)))
//create time validation.
worksheet.getRange("C2:E4").validation.add(ValidationType.Time, ValidationAlertStyle.Stop, ValidationOperator.Between, GregorianCalendar(1899, 11, 30, 13, 30, 0), GregorianCalendar(1899, 11, 30, 18, 30, 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("CreateTimeValidation.xlsx")