How to remove data validation from the specified range?

4 Nov 20252 minutes to read

You can remove data validation from the specified range using the Clear method with the ExcelClearOptions of ClearDataValidations option.

The following code example demonstrates how to remove data validation from the specified range.

using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;
    IWorkbook workbook = application.Workbooks.Open("InputTemplate.xlsx");
    IWorksheet worksheet = workbook.Worksheets[0];

    //Removes data validation from the specified range           
    worksheet.Range["A1:C5"].Clear(ExcelClearOptions.ClearDataValidations);

    //Saving the workbook 
    workbook.SaveAs("Output.xlsx");
}
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    application.DefaultVersion = ExcelVersion.Xlsx;
    IWorkbook workbook = application.Workbooks.Open("InputTemplate.xlsx");
    IWorksheet worksheet = workbook.Worksheets[0];

    //Removes data validation from the specified range           
    worksheet.Range["A1:C5"].Clear(ExcelClearOptions.ClearDataValidations);

    //Saving the workbook
    workbook.SaveAs("Output.xlsx");
}
Using excelEngine As ExcelEngine = New ExcelEngine()
    Dim application As IApplication = excelEngine.Excel
    application.DefaultVersion = ExcelVersion.Xlsx
    Dim workbook As IWorkbook = application.Workbooks.Open("InputTemplate.xlsx")
    Dim worksheet As IWorksheet = workbook.Worksheets(0)

    'Removes data validation from the specified range
    worksheet.Range("A1:C5").Clear(ExcelClearOptions.ClearDataValidations)

    'Saving the workbook
    workbook.SaveAs("Output.xlsx")
End Using