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

Data Validations

Nov 8, 2014 at 8:20 PM
Is it possible to add data validations that come from a data source? I want to have the dropdown list come from my database lookup tables, as opposed to a range of existing cells.

I am creating a template, so the data validation would have to apply to the entire column, not just a cell.

Nice library!

Garth
Nov 8, 2014 at 9:12 PM
How would you do it in Excel?
Nov 10, 2014 at 12:42 PM
In data validations you create a list, but instead of specifying a range, its a comma separated list of values.

So "one,two,three" becomes a dropdown of these three values.
Nov 10, 2014 at 4:48 PM
cell.DataValidation.List("\"one,two,three\"");