从GridView导出到Excel 加行
private void toexcel(string title)
{
try
{
Encoding encContent = Encoding.GetEncoding("utf-8");
int count = GridView1.Columns.Count;
Response.Clear();
Response.ClearContent();
Response.ClearHeaders();
Response.Buffer = true;
Response.Charset = encContent.WebName;
Response.ContentEncoding = encContent;
Response.ContentType = "application/vnd.ms-excel";
Response.Write(string.Format("<meta http-equiv=Content-Type content=text/html;charset={0}>", encContent.WebName));
string rename = HttpUtility.UrlEncode(title, Encoding.UTF8);
Response.AppendHeader("content-disposition", string.Format("attachment;filename={0}.xls", rename));
StringBuilder titleName = new StringBuilder();
string colspanCount = string.Format("<table><tr><td colspan=\"{0}\"", count);
titleName.Append(colspanCount);
titleName.Append("style=\"font-family:宋体;font-size:12.0pt;font-weight:700;");
titleName.Append("text-align:center;vertical-align:middle;\">");
titleName.Append(string.Format("{0}</td></tr></table>", title));
EnableViewState = false;
StringWriter sw = new StringWriter();
HtmlTextWriter htw = new HtmlTextWriter(sw);
this.GridView1.RenderControl(htw);
Response.Write(AddExcelHead(title));
Response.Write(titleName.ToString());
Response.Write(sw.ToString());
Response.Write(AddExcelbottom());
sw.Close();
Response.End();
}
catch
{
}
}
protected void btn_toexcel_Click(object sender, EventArgs e)
{
string orderid = "";
if (Request.Params["id"] != null)
{
orderid = Request.Params["id"].ToString();
}
toexcel("订单" + orderid + "详细");
}
public static string AddExcelHead(string title)
{
StringBuilder sb = new StringBuilder();
sb.Append("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
sb.Append(" <head>");
sb.Append(" <!--[if gte mso 9]><xml>");
sb.Append("<x:ExcelWorkbook>");
sb.Append("<x:ExcelWorksheets>");
sb.Append("<x:ExcelWorksheet>");
sb.Append(string.Format("<x:Name>{0}</x:Name>", title));
sb.Append("<x:WorksheetOptions>");
sb.Append("<x:Print>");
sb.Append("<x:ValidPrinterInfo />");
sb.Append(" </x:Print>");
sb.Append("</x:WorksheetOptions>");
sb.Append("</x:ExcelWorksheet>");
sb.Append("</x:ExcelWorksheets>");
sb.Append("</x:ExcelWorkbook>");
sb.Append("</xml>");
sb.Append("<![endif]-->");
sb.Append(" </head>");
sb.Append("<body>");
return sb.ToString();
}
public static string AddExcelbottom()
{
StringBuilder sb = new StringBuilder();
sb.Append("</body>");
sb.Append("</html>");
return sb.ToString();
}
public override void VerifyRenderingInServerForm(Control control)
{
}
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· Linux系列：如何用heaptrack跟踪.NET程序的非托管内存泄露
· 开发者必知的日志记录最佳实践
· SQL Server 2025 AI相关能力初探
· Linux系列：如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列（二）：开始使用ML.NET
· 无需6万激活码！GitHub神秘组织3小时极速复刻Manus，手把手教你使用OpenManus搭建本
· C#/.NET/.NET Core优秀项目和框架2025年2月简报
· Manus爆火，是硬核还是营销？
· 终于写完轮子一部分：tcp代理 了，记录一下
· 【杭电多校比赛记录】2025“钉耙编程”中国大学生算法设计春季联赛（1）