Export to Excel in VB.NET Windows Application.

In addition to answer by Uday:

Don't export content of any controls to other controls, prints, reports, export document. You need to have a separate data layer. Probably you already using some data layer to bind with you data grid. Use data for generation of PDF, not data grid or any other control.

If this is not clear (and even it it is clear), learn about the following architectural patterns (http://en.wikipedia.org/wiki/Architectural_pattern_(computer_science)[^]):

MVVM — Model View View Model,
http://en.wikipedia.org/wiki/Model_View_ViewModel[^],

MVC — Model-View-Controller,
http://en.wikipedia.org/wiki/Model-view-controller[^]),

MVA — Model-View-Adapter,
http://en.wikipedia.org/wiki/Model–view–adapter[^],

MVP — Model-View-Presenter,
http://en.wikipedia.org/wiki/Model-view-presenter[^].

Pay attention for the motivation of those architectures. If you understand it, you would be able to create better design ideas.

—SA

Protected Sub btnsndexl_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnsndexl.Click
        If gdhidden.Rows.Count > 0 Then
            ExportGridView()
        Else
            ScriptManager.RegisterClientScriptBlock(btnsndexl, Me.GetType(), "MyScript", "alert('No Record Found');", True)
        End If
    End Sub

Private Sub ExportGridView()
       gdhidden.Visible = True
       Dim attachment As String = "attachment; filename=Report.xls"
       Response.ClearContent()
       Response.AddHeader("content-disposition", attachment)
       Response.ContentType = "application/ms-excel"
       Dim sw As New IO.StringWriter
       Dim htw As New UI.HtmlTextWriter(sw)
       gdhidden.RenderControl(htw)
       Response.Write(sw.ToString())
       Response.End()
       gdhidden.Visible = False
   End Sub

What if I want to export two datagridviews (Parent/Child ) on excel?

and the output is like this:

Parent Parent Parent
Child Child Child
Parent Parent Parent
Child Child Child
Parent Parent Parent
Child Child Child