This project has moved and is read-only. For the latest updates, please go here.

How to read cell that has dropdown list (datavalidations)

Sep 23, 2015 at 12:53 PM
Hi there,

I created an excel workbook that has a worksheet in wich I added a dropdown list

The code I used to create the dropdown:
var validationCell = worksheet.DataValidations.AddListValidation("C3");

Usually to read a cell it's only required:
string value = worksheet.Cells["C3"].Value

But since it was created using a datavalidation, the worksheet.Cells["C3"].Value it always returns ""

Can anyone help me? :)

Kind regards.