title: ClosedXML and digits as text
body: <p>I am using <code>ClosedXML</code> to export data from SQL Data Table to Excel.</p>
  
  <p>This is part of exporting: (dt is a datatable with data from SQL Server)</p>
  
  <pre><code> using (XLWorkbook wb = new XLWorkbook())
              {
                  wb.Worksheets.Add(dt);
  
                  Response.Clear();
                  Response.Buffer = true;
                  Response.Charset = "";
  Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
                  Response.ContentType = "application/vnd.ms-excel";
                  Response.AddHeader("content-disposition", "attachment;filename=Report.xlsx");
                  using (MemoryStream MyMemoryStream = new MemoryStream())
                  {
                      wb.SaveAs(MyMemoryStream);
                      MyMemoryStream.WriteTo(Response.OutputStream);
                      Response.Flush();
                      Response.End();
                  }
              }
  </code></pre>
  
  <p>The problems are:</p>
  
  <ul>
  <li><p>After exporting all digits are as text</p></li>
  <li><p>Decimal digits have a dot but should have a comma</p></li>
  </ul>
  
  <p>Please, could somebody help me how to correctly format my export to Excel ?</p>