how to export multiple asp panels to excel

See more:

VB

SQL

I want to know how to export multiple panels to excel. I got this code:

Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename= Report.xls")
Response.Charset = ""
Response.ContentType = "application/vnd.ms-excel"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)
Panel4.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Response.End()

It only works for 1 panel only. If I add another panel and add in the code still doesn't work. is there any way to do this?

This is my code for 2 panels:

Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename= Report.xls")
Response.Charset = ""
Response.ContentType = "application/vnd.ms-excel"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)
Dim stringWrite2 As New System.IO.StringWriter()
Dim htmlWrite2 As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite2)
Panel4.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Panel2.RenderControl(htmlWrite2)
Response.Write(stringWrite2.ToString())
Response.End()