Export DataTable to Excel with EPPlus

by 
using (ExcelPackage pck = new ExcelPackage(newFile))
{
  ExcelWorksheet ws = pck.Workbook.Worksheets.Add("Accounts");
  ws.Cells["A1"].LoadFromDataTable(dataTable, true);
  pck.Save();
}

That should do the trick for you. If your fields are defined as int EPPlus will properly cast the columns into a number or float.

More Related Contents:

  1. Export DataTable to Excel File
  2. How to export DataTable to Excel
  3. Format excel column to decimal doing export from c#
  4. export to Excel from a list with EPPLUS
  5. Excel to DataTable using EPPlus – excel locked for editing
  6. How to create CSV Excel file C#? [closed]
  7. C# create/modify/read .xlsx files
  8. EPPlus number format
  9. EPPlus Large Dataset Issue with Out of Memory Exception
  10. EPPlus – LoadFromCollection – Text converted to number
  11. How do I properly clean up Excel interop objects?
  12. Sorting rows in a data table
  13. Combining n DataTables into a Single DataTable
  14. How do I export to Excel?
  15. How to insert a data table into SQL Server database table?
  16. .NET – Convert Generic Collection to DataTable
  17. Exception using CopyToDataTable with “new {..}” LINQ query
  18. How to read data from excel file using c# [duplicate]
  19. Excel interop: _Worksheet or Worksheet?
  20. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  21. How to add data table with legend keys to a MS Chart in C#?
  22. How can I programmatically create, read, write an excel without having office installed?
  23. SqlBulkCopy – The given value of type String from the data source cannot be converted to type money of the specified target column
  24. Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error
  25. Mapping columns in a DataTable to a SQL table with SqlBulkCopy
  26. How can I convert a DataTable into a Dynamic object?
  27. openxml spreadsheat save-as
  28. Scientific notation when importing from Excel in .Net
  29. Accessing an open Excel Workbook in C#
  30. Import Excel to Datagridview

Leave a Comment