asp.net 导出Excel

最新推荐文章于 2025-08-19 13:51:22 发布

转载最新推荐文章于 2025-08-19 13:51:22 发布 · 523 阅读

文章标签：

#asp.net #excel #string #object #border #office

asp.net 专栏收录该内容

17 篇文章

订阅专栏

本文介绍了一种使用ASP.NET将数据导出为Excel的方法，包括设置响应头、生成表格内容及导出流程。该方法适用于导出简单表格数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1.添加Excel引用

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Outputexecl(sender, e);
                     }
        }

        protected void Outputexecl(object sender, EventArgs e)
        {
            //string fileName = "test.xls";//设置导出文件的名称
            HttpContext curContext = System.Web.HttpContext.Current;
            curContext.Response.ContentType = "application/vnd.ms-excel";
            curContext.Response.ContentEncoding = System.Text.Encoding.Default;
            curContext.Response.AppendHeader("Content-Disposition", "attachment;filename=test.xls");
            curContext.Response.Charset = "";
            curContext.Response.Write(AddExcelHead());//显示excel的网格线
            curContext.Response.Write(ExportTable(getData()));//导出
            curContext.Response.Write(AddExcelbottom());//显示excel的网格线
            curContext.Response.Flush();
            curContext.Response.End();
        }

        public DataTable getData()
        {
            Test users = new Test();
            DataTable dt = users.GetAll();
            return dt;
        }

        #region
        public static string ExportTable(DataTable tb)
        {
            string data = "";
            data += "<table cellspacing='0' cellpadding='5' rules='all' border='0'>";
            //写出列名
            data += "<tr style='font-weight: bold; white-space: nowrap;'>";
            //foreach (DataColumn column in tb.Columns)
            //{
            //    data += "<td>" + column.ColumnName + "</td>";
            //}
            data += "<td>用户名</td>";
            data += "<td>密码</td>";
            data += "<td>注册时间</td>";
            data += "</tr>";

            //写出数据
            foreach (DataRow row in tb.Rows)
            {
                data += "<tr>";
                foreach (DataColumn column in tb.Columns)
                {
                    data += "<td>" + row[column].ToString() + "</td>";
                }
                data += "</tr>";
            }
            data += "</table>";

return data;
}

public static string AddExcelHead()
        {
            System.Text.StringBuilder sb = new System.Text.StringBuilder();
            sb.Append("<html xmlns:x='urn:schemas-microsoft-com:office:excel'>");
            sb.Append(" <head>");
            sb.Append(" ");
            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();
        }
        #endregion

导出Excel有个问题，就是导出之后打开文件，如果后缀名为 xlsx 会打不开，xls才能打开，这个问题还没解决