title: converting into integer in excel using EPPlus (asp.net)
body: <p>I am loading data into excel from datatable using <code>LoadFromDataTable</code> method then changed cell format to integer still it is showing error <strong>"The number in this cell is formatted as text or preceded by apostrophe"</strong>. </p>
  
  <p>cell was showing to right side only and number format only on cell property.</p>
  
  <p>still I am not understanding why I am getting this error??.</p>
  
  <pre><code>Dim wsManufacturing As ExcelWorksheet = pck.Workbook.Worksheets.Add("Manufacturing")
  wsManufacturing.Cells("A1").LoadFromDataTable(dtManufacturing, True)
   Using col As ExcelRange = wsManufacturing.Cells(2, 2, 2 + dtManufacturing.Rows.Count, 2)
      col.Style.Numberformat.Format = "#,##0"
      col.Style.HorizontalAlignment = ExcelHorizontalAlignment.Right
   End Using
  </code></pre>
  
  <p><img src="https://i.stack.imgur.com/bz4Cm.jpg" alt="enter image description here"></p>