title: Data validation for combo box range of column using EPPlus
body: <p>I using EPplus for exporting excel.i have to give a combo box.Currently i have given the range manually.but i want this dropdown for entire column.Can any one tell how to do this </p>
  
  <pre><code>ExcelPackage excel = new ExcelPackage();
   ExcelWorksheet P = excel.Workbook.Worksheets.Add("Pass");
  
   var droplist = P.DataValidations.AddListValidation("C2:C50000");   
   droplist.Formula.Values.Add("a");
   droplist.Formula.Values.Add("b");
  </code></pre>