Data validation in imported Excelfile

Question

My imported Excel-file not showing the the Data validation Dropdown in Excel-cell.how to check cell has dropdownload to build list manuallyGrettings Jens

Arulpriya Ramalingam · Answer

Hi Jens, 
 
Greetings from Syncfusion support. 
 
The DataValidation of a cell will be updated in the spreadsheet when a workbook is imported. The HasDataValidation property of IRange will update that whether the cell has dropdown for data validation. Please make use of the below code example. 
 
Example code 
 




//To check whether a cell has data validation. 
bool dataValid = spreadsheet.ActiveSheet.Range["C14"].HasDataValidation; 
 
UG link: https://help.syncfusion.com/windowsforms/spreadsheet/editing#data-validation 
 
Please get back to us, if you need any further assistance. 
 
Regards, 
Arulpriya