Missing rows after exporting to excel...

Hi,

Anyone can help me? thks...

Justin

Hi Justin,

justin00:

Anyone can help me? thks...

the community members around here are very willing to help out but without seeing some actual, relevant, code that you already created it's going to be somewhat difficult.

Grz, Kris.

Thanks for the fast reply..Kris.

This is how my code goes for exporting, pnlCC is my panel name:

Response.Clear()
Response.Buffer =

True
Response.ContentType = "application/vnd.ms-excel"
Response.Charset = ""
Response.ContentEncoding = System.Text.Encoding.UTF7
Response.AddHeader("Content-Disposition", "attachment;filename=TemporaryFile.xls")
Me.EnableViewState =False
Dim oStringWriterAs System.IO.StringWriter =New System.IO.StringWriter()
Dim oHtmlTextWriterAs System.Web.UI.HtmlTextWriter =New System.Web.UI.HtmlTextWriter(oStringWriter)pnlCC.RenderControl(oHtmlTextWriter)
Response.Write(oStringWriter.ToString())
Response.End()

I have no problem exporting to excel, but last few rows seem to be cut off after export.
Thanks...hope someone have some ideas on this problem.