如何在DataGrid中导出数据到Excel后控制Excel显示格式?
我是这样导出数据的:
在导出按钮的OnClick()事件中写以下代码,但是导出后Excel格式如何去控制?
if(this.dgrdDetail.Items.Count > 0)
{
Response.Clear();
Response.Buffer= true;
Response.Charset = "UTF-8";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AppendHeader("Content-Disposition","attachment;filename=Excel.xls"); //导出到Excel
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false;
CultureInfo myCItrad = new CultureInfo("ZH-CN",true);
HtmlGenericControl div = new HtmlGenericControl();
System.IO.StringWriter tw = new System.IO.StringWriter(myCItrad);
div.InnerHtml = tw.ToString();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
this.dgrdDetail.ShowHeader = true;
this.dgrdDetail.BorderWidth = 1;
this.dgrdDetail.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
}
else
{
this.RegisterStartupScript("key","<script>alert('无数据可导出!');</script>");
}