dato from grid into Excel

[anonymous]

I have the following code where I get all data into
excel. However my grid has a paging option set to 'Y'
and with the paging it is not working.
What should be modified in order to fix this problem?
Dim tw As New System.IO.StringWriter
Dim hw As New System.Web.UI.HtmlTextWriter(tw)
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader("Content-
Disposition", "inline;filename=test.xls")
Response.Charset = ""
Me.EnableViewState = False
grdReport.RenderControl(hw)
Response.Write(tw.ToString())
Response.End()