C#导出excel文件

最新推荐文章于 2024-09-16 16:05:38 发布

wsxqaz

最新推荐文章于 2024-09-16 16:05:38 发布

阅读量669

点赞数

文章标签： excel c# office html xml

            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Buffer = true;

            StringBuilder strBld = new StringBuilder();
            strBld.Append("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
            strBld.Append("<head>");
            strBld.Append("<!--[if gte mso 9]><xml>");
            strBld.Append("<x:ExcelWorkbook>");
            strBld.Append("<x:ExcelWorksheets>");
            strBld.Append("<x:ExcelWorksheet>");
            strBld.Append("<x:Name>sheet1</x:Name>");
            strBld.Append("<x:WorksheetOptions>");
            strBld.Append("<x:Print>");
            strBld.Append("<x:ValidPrinterInfo/>");
            strBld.Append("</x:Print>");
            strBld.Append("</x:WorksheetOptions>");
            strBld.Append("</x:ExcelWorksheet>");
            strBld.Append("</x:ExcelWorksheets>");
            strBld.Append("</x:ExcelWorkbook>");
            strBld.Append("</xml>");
            strBld.Append("<![endif]--> ");
            strBld.Append("</head>");
            strBld.Append("<body>");

            HttpContext.Current.Response.Write(strBld.ToString());

            HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + DateTime.Now.ToString("yyyyMMdd") + ".xls");

            HttpContext.Current.Response.Charset = "UTF-8";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
            HttpContext.Current.Response.HeaderEncoding = System.Text.Encoding.UTF8;

            HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";

            HttpContext.Current.Response.Write("<meta http-equiv='content-type' content='application/ms-excel; charset=UTF-8'/>");

            HttpContext.Current.Response.Write(contentHtml);
            HttpContext.Current.Response.Write("</body></html>");
            HttpContext.Current.Response.End();

contentHtml就是htmltable，比如：<table><tr><td>111</td></tr></table>