title: Epplus: When using LoadFromCollection, boolean column is blank in exported Excel file
body: <p>In my MVC application, I have an ActionResult that loads an IEnumerable and exports it to an Excel File. That part works great, unless I have a boolean column. In that case, the values of the boolean column are blank.</p>
  
  <p>Are boolean columns not supported by LoadFromCollection?</p>
  
  <p>To resolve this, I could create a separate field in the model that translates the boolean value to a string value. However, I was hoping I could add a statement in the <code>ExcelPackage()</code> block that does the job without needing to adjust the model. Is this possible, or is rewriting the model the only possible solution?</p>
  
  <pre><code>public ActionResult ExportToExcel(string _searchString, string _setScale)
  {                
     // This is the query result set the user wishes to export to file
     IEnumerable&lt;CreditsAllsExport&gt; exportQuery;
     /* ... irrelevant code redacted ... */
     exportQuery = exportQuery.AsEnumerable();
  
     byte[] response;
     using (var excelFile = new ExcelPackage())
     {
        /* ... irrelevant code redacted ... */
        worksheet.Cells["A5"].LoadFromCollection(Collection: exportQuery, PrintHeaders: true);
  
        /* TRANSLATE BOOLEAN TO Yes or No */
  
        response = excelFile.GetAsByteArray();
    }
  
    /* ... irrelevant code redacted ... */
  }
  </code></pre>