62,046
社区成员
发帖
与我相关
我的任务
分享
Response.Clear();
Response.Buffer = true;
string pagename = System.IO.Path.GetFileName(Request.Path).ToString();
pagename = pagename.Replace(".aspx", "");
//为了防止重名,获得日期为文件名年月日时分秒毫秒
string datetime = System.DateTime.Now.ToString("yyyMMddHHmmss");
string FileName = pagename + datetime + ".xls";
Response.Charset = "GB2312";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8).ToString());
// 如果设置为 GetEncoding("GB2312");导出的文件将会出现乱码!!!
Response.ContentEncoding = System.Text.Encoding.UTF7;
Response.ContentType = "application/ms-excel";//设置输出文件类型为excel文件。
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.GridView1.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();
Response.Close();
System.Web.UI.WebControls.DataGrid dgExport = null;
if (dtData != null)
{
Response.ClearContent();
Response.AddHeader("content-disposition", "attachment;filename=" + Server.UrlEncode("xxxx.xls"));
Response.ContentType = "application/xls";
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
sw.WriteLine("<div align=\"center\">xxx</div>");
sw.WriteLine("<br />");
//为了解决dgData中可能进行了分页的情况,需要重新定义一个无分页的DataGrids
dgExport = new System.Web.UI.WebControls.DataGrid();
dgExport.DataSource = dtData;
dgExport.DataBind();
dgExport.RenderControl(htw);
Response.Write(sw.ToString());
Response.End();
}