Excel API Library for .NET - Sample Browser | Document Solutions | Create time validation

[フレーム]

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
var workbook = new GrapeCity.Documents.Excel.Workbook();
IWorksheet worksheet = workbook.Worksheets[0];
worksheet.Range["C2:E4"].Value = new object[,]
{
 {new TimeSpan(13, 0, 0), new TimeSpan(13, 29, 59), new TimeSpan(13, 30, 0)},
 {new TimeSpan(14, 0, 0), new TimeSpan(15, 0, 0), new TimeSpan(16, 30, 0)},
 {new TimeSpan(19, 0, 0), new TimeSpan(18, 29, 59), new TimeSpan(18, 30, 0)}
};
//create time validation.
worksheet.Range["C2:E4"].Validation.Add(ValidationType.Time, ValidationAlertStyle.Stop, ValidationOperator.Between, new TimeSpan(13, 30, 0), new TimeSpan(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.Range[i, j].HasValidation)
 {
 //set the range[i, j]'s interior color.
 worksheet.Range[i, j].Interior.Color = Color.LightBlue;
 }
 }
}
 
// Save to an excel file
workbook.Save("CreateTimeValidation.xlsx");


 
 ' Create a new Workbook
Dim workbook As New Workbook
Dim worksheet As IWorksheet = workbook.Worksheets(0)
worksheet.Range("C2:E4").Value = New Object(,) {
 {
 New TimeSpan(13, 0, 0),
 New TimeSpan(13, 29, 59),
 New TimeSpan(13, 30, 0)
 },
 {
 New TimeSpan(14, 0, 0),
 New TimeSpan(15, 0, 0),
 New TimeSpan(16, 30, 0)
 },
 {
 New TimeSpan(19, 0, 0),
 New TimeSpan(18, 29, 59),
 New TimeSpan(18, 30, 0)
 }
}
'create time validation.
worksheet.Range("C2:E4").Validation.Add(ValidationType.Time, ValidationAlertStyle.Stop, ValidationOperator.Between, New TimeSpan(13, 30, 0), New TimeSpan(18, 30, 0))
'judge if Range("C2:E4") has validation.
For i As Integer = 1 To 3
 For j As Integer = 2 To 4
 If worksheet.Range(i, j).HasValidation Then
 'set the range(i, j)'s interior color.
 worksheet.Range(i, j).Interior.Color = Color.LightBlue
 End If
 Next j
Next i
 
' save to an excel file
workbook.Save("CreateTimeValidation.xlsx")