Winforms DataTable Convert to Excel

Question

In asp.net, it is quite easy to convert a datatable to an excel file. How do I do the same for datatables in winforms?

For Example: in my asp.net code, here is my function to convert the datatable to excel:

Public Shared Sub DataTableToExcel(ByVal dt As DataTable, ByVal FileName As String
  HttpContext.Current.Response.Clear()
  HttpContext.Current.Response.Write(Environment.NewLine)
  For Each row As DataRow In dt.Rows
    For i As Integer = 0 To dt.Columns.Count - 1
      HttpContext.Current.Response.Write(row(i).ToString().Replace(";", String.Empty) + ";")
    Next

    HttpContext.Current.Response.Write(Environment.NewLine)
  Next

  HttpContext.Current.Response.ContentType = "application/ms-excel"
  HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment; filename=" + FileName + ".xls")
  HttpContext.Current.Response.[End]()
End Sub

But in winforms, you cannot use the same as it is. You need to read out the datatable and create/open the excel workbook.

I wish there is a way to directly convert datatable used in winforms to excel fast.

Thanks.

Answer 1

Check the following link:

c# (WinForms-App) export DataSet to Excel

Answer 2

One of my favourite method of exporting to Excel is use OLE DB automation

Other useful links to interesting approaches:

http://support.microsoft.com/kb/306023
http://www.eggheadcafe.com/forumpost.aspx?topicid=2&forumpostid=3954
http://support.microsoft.com/default.aspx?scid=kb;EN-US;316934
http://www.codeproject.com/KB/vb/Senthil%5FS%5F%5FSoftware%5FEng%5F.aspx