Export multiple gridview data in a excel file

Protected Sub btnExport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExport.Click
If GridView1.Rows.Count.ToString + 1 < 65536 Then
Dim tw As New StringWriter()
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
Dim frm As HtmlForm = New HtmlForm()
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("content-disposition", "attachment;filename=" & "report.xls")
Response.Charset = ""
EnableViewState = False
Controls.Add(frm)
frm.Controls.Add(GridView1)
frm.Controls.Add(GridView2)
frm.Controls.Add(GridView3)
frm.RenderControl(hw)
Response.Write(tw.ToString())
Response.End()
End If
End Sub

Comments

Popular Posts