//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)); //delete validation. worksheet.Range["C2:E4"].Validation.Delete(); //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("DeleteValidation.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)) 'delete validation. worksheet.Range("C2:E4").Validation.Delete() '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("DeleteValidation.xlsx")