Tutorial by Examples

You can read all items either from any config file or type it inline. Considering if its saved in Config File // Read all list items from config file string[] countryDV = ConfigurationManager.AppSettings["countryDV"].Split(',').Select(s => s.Trim().ToUpper()).ToArray(); int DVRowLim...

Approach in this case will be different than previous example because Excel file supports the Data validation for list of items with total character count less than 256 if all items are binded directly as in previous example. But in many situation list items can be longer than 256 characters and in ...