How to export DataTable to Excel

by

I would recommend ClosedXML –

You can turn a DataTable into an Excel worksheet with some very readable code:

XLWorkbook wb = new XLWorkbook();
DataTable dt = GetDataTableOrWhatever();
wb.Worksheets.Add(dt,"WorksheetName");

The developer is responsive and helpful. The project is actively developed, and the documentation is superb.

More Related Contents:

  1. Export DataTable to Excel with EPPlus
  2. Export DataTable to Excel File
  3. Affect the datatable column value in C#
  4. How do I properly clean up Excel interop objects?
  5. Convert datatable to JSON in C#
  6. How to select distinct rows in a datatable and store into an array
  7. Format excel column to decimal doing export from c#
  8. Combining n DataTables into a Single DataTable
  9. How do I export to Excel?
  10. How to read file using NPOI
  11. Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))
  12. Check if value exists in dataTable?
  13. EPPlus number format
  14. How to insert a data table into SQL Server database table?
  15. .NET – Convert Generic Collection to DataTable
  16. Exception using CopyToDataTable with “new {..}” LINQ query
  17. How to read data from excel file using c# [duplicate]
  18. Excel interop: _Worksheet or Worksheet?
  19. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  20. How to add data table with legend keys to a MS Chart in C#?
  21. How to fill a datatable with List [duplicate]
  22. Copy rows from one Datatable to another DataTable?
  23. How can I programmatically create, read, write an excel without having office installed?
  24. Why appending AutoFilter corrupts my excel file in this example?
  25. SqlBulkCopy – The given value of type String from the data source cannot be converted to type money of the specified target column
  26. Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error
  27. How to convert DataTable to class Object?
  28. Using ExcelDataReader to read Excel data starting from a particular cell
  29. EPPlus – LoadFromCollection – Text converted to number
  30. .Net Excel Interop Deleting a worksheet

Leave a Comment