Exporting simple gridview to excel

I have below markup in .aspx page

and below code behind i am using it runs normally but does not show any exported file

Protected Sub ExportToExcel(sender As Object, e As EventArgs)

Response.Clear()

Response.Buffer = True

Response.AddHeader("content-disposition", "attachment;filename=GridViewExport.xls")

Response.Charset = ""

Response.ContentType = "application/vnd.ms-excel"

Using sw As New StringWriter()

Dim hw As New HtmlTextWriter(sw)

'To Export all pages

grdUserReports.AllowPaging = False

Me.SearchReportUser()

grdUserReports.HeaderRow.BackColor = Color.White

For Each cell As TableCell In grdUserReports.HeaderRow.Cells

cell.BackColor = grdUserReports.HeaderStyle.BackColor

For Each row As GridViewRow In grdUserReports.Rows

row.BackColor = Color.White

For Each cell As TableCell In row.Cells

If row.RowIndex Mod 2 = 0 Then

cell.BackColor = grdUserReports.AlternatingRowStyle.BackColor

Else

cell.BackColor = grdUserReports.RowStyle.BackColor

End If

cell.CssClass = "textmode"

grdUserReports.RenderControl(hw)

'style to format numbers to string

Dim style As String = ""

Response.Write(style)

Response.Output.Write(sw.ToString())

Response.Flush()

Response.[End]()

End Using

End Sub

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Saroj Kumar Sahu11y ago
Hi,
If you want update panel then u need to add one trigger for button click inside the update panel.
ControlID="btnExport" />
If no luck,please attach your code sample as zip format.
0
Upendra Pratap Shahi11y ago
if you don't want to drop your update panel then also bind the data of gridview in excel exporting function or use JSON for binding this.
0
Danish Habib11y ago
Yes it is in update panel i cannot drop the gridview from update panel because update panel is also my requirement
0
Upendra Pratap Shahi11y ago
your gridview in update panel?
0