How to clear all DataValidation from the worksheet?

Question

The code below doesn't work._sfSpreadsheet.ActiveSheet.Clear();

Santhosh Govindasamy · Answer

Hi crosslife,Thank you for reaching out.

Based on the information provided, you want to remove all data validations from
the worksheet. This can be accomplished by using the
ExcelClearOptions.ClearDataValidations API, which allows you to clear all data
validations from the worksheet.

Code Snippet:

private void btn_Click(object sender, RoutedEventArgs e)
   {
       spreadsheet.Workbook.Worksheets[0].Range.Clear(Syncfusion.XlsIO.ExcelClearOptions.ClearDataValidations);
   }

For your reference, we have attached the sample and video. Please review them.

Regards,
Santhosh.GAttachment: SpreadSheetDemo_793bb0c0.zip