protected void cmdExportExcel_Click(object sender, EventArgs e)
{
startTime = Session["startTime"] as string;
endTime = Session["endTime"] as string;
string templateFileName = "催收员排名统计报告" + DateTime.Now.ToString("yyyy-MM-dd") + ".xls";
DumpExcel(this.dvResult, templateFileName);
}
private void DumpExcel(GridView gv, string FileName)
{//带格式导出
string style = @"<style> .text { } </script>";
Response.ClearContent();
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.Default;
Response.AddHeader("content-disposition", "attachment; filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
Response.ContentType = "application/excel";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
gv.RenderControl(htw);
// Style is added dynamically
Response.Write(style);
Response.Write(sw.ToString());
Response.End();
}
//处理GridView应该放在 runat="server"问题
public override void VerifyRenderingInServerForm(Control control)
{
//这里什么也不用写
}