ASP.NET导出Excel文件问题，导出后表里没内容

[Cerulean_ZC]

我用以下方法做的导出，为什么导出的Excel文件没有内容?谢谢大家帮个忙
HttpContext.Current.Response.Clear();
HttpContext.Current.Response.Buffer= true;
HttpContext.Current.Response.Charset="utf-8";

HttpContext.Current.Response.AppendHeader("Content-Disposition","attachment;filename=会员消费汇总表.xls");
HttpContext.Current.Response.ContentEncoding=System.Text.Encoding.Default;

HttpContext.Current.Response.ContentType = "application/ms-excel";
this.EnableViewState = false;

System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);

this.rpResult.RenderControl(oHtmlTextWriter);

HttpContext.Current.Response.Write(oStringWriter.ToString());
HttpContext.Current.Response.End();

[ChengKing]

这样导出不是最正确的方式,请参考:
http://blog.csdn.net/ChengKing/archive/2005/11/29/539514.aspx

[duyhui]

rpResult控件里没有内容吧?

[lovechenlila]

我也做好了,我做的就是导出时不能导中文字体

[nnh]

Sub ExportToExcel_Click(s as object, e as eventargs)
'-------------------
MyDataGrid.AllowPaging = "false"
BindGrid()
'-------------------

Response.Clear
Response.AddHeader("content-disposition", "attachment;filename=FileName.xls")
Response.Charset = ""
Response.Cache.SetCacheability(HttpCacheability.NoCache)
Response.ContentType = "application/vnd.xls"
Dim stringWrite As System.IO.StringWriter = New System.IO.StringWriter
Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)
MyDataGrid.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString)
Response.End

'-------------------
MyDataGrid.AllowPaging = "true"
BindGrid()
'-------------------
End Sub

[HELLO_JIM]

學習中.............