title: How to read Excel Dropdown value using ClosedXML
body: <p><em>I have a excel which has some fields as a dropdown, need to get entire list of the dropdown has.
  I tried to use the ClosedXML for this. I can able to find whether it is list or not.
  But unable to read the entire list?</em></p>
  <pre><code>     using(var workbook = new XLWorkbook(&quot;C:\Data\Test.xlsx&quot;))
      {
          var workSheetTable = workbook.Worksheets.Worksheet(&quot;Template1&quot;);
  
          var dropdownList = workSheetTable.Range(&quot;A5:F5&quot;);
          var datavalid = workSheetTable.DataValidations.
              GetAllInRange(dropdownList.RangeAddress).ToList();
  
          foreach (var dataValidation in workSheetTable.DataValidations)
          {
              if (dataValidation.AllowedValues == XLAllowedValues.List)
              {
                  //How to get values of the list
              }
          }
      }
  </code></pre>