//打印Excel表格
public void ExportToExcel(Page myPage, GridView ctl, string filename)
{
HttpResponse Response;
Response = myPage.Response;
bool CurrCtlVisible = ctl.Visible;
ctl.Visible = true;
Response.HeaderEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + filename + ".xls");
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.ContentType = "application/ms-excel";
ctl.Page.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new HtmlTextWriter(tw);
ctl.RenderControl(hw);
Response.Write(tw.ToString());
Response.End();
ctl.Page.EnableViewState = true;
ctl.Visible = CurrCtlVisible;
}
把Gridview换成datalist也可以
- 1
- 2
前往页