CTL.Common/Utils.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.IO;
using System.Text;
using System.Text.RegularExpressions;
using System.Collections;
using System.Web;
using System.Data;


namespace CTL.Common
{
    /// <summary>
    /// 工具类
    /// </summary>
    public class Utils
    {
        /// <summary>
        /// 导出数据到Excel中
        /// </summary>
        /// <param name="exportData">要导出的数据</param>
        /// <param name="fileName">文件名称</param>
        public static void Export(StringBuilder exportData, string fileName)
        {
            StringBuilder sHtml = new StringBuilder();
            string sheetName = "sheetName";
            sHtml.Append("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
            sHtml.Append("<head>");
            sHtml.Append("<!--[if gte mso 9]>");
            sHtml.Append("<xml>");
            sHtml.Append("<x:ExcelWorkbook>");
            sHtml.Append("<x:ExcelWorksheets>");
            sHtml.Append("<x:ExcelWorksheet>");
            sHtml.Append("<x:Name>" + sheetName + "</x:Name>");
            sHtml.Append("<x:WorksheetOptions>");
            sHtml.Append("<x:Print>");
            sHtml.Append("<x:ValidPrinterInfo />");
            sHtml.Append("</x:Print>");
            sHtml.Append("</x:WorksheetOptions>");
            sHtml.Append("</x:ExcelWorksheet>");
            sHtml.Append("</x:ExcelWorksheets>");
            sHtml.Append("</x:ExcelWorkbook>");
            sHtml.Append("</xml>");
            sHtml.Append("<![endif]-->");
            sHtml.Append("</head>");
            sHtml.Append("<body>");
            sHtml.Append(exportData);
            sHtml.Append("</body>");
            sHtml.Append("</html>");

            HttpContext.Current.Response.Clear();
            HttpContext.Current.Response.Buffer = true;
            HttpContext.Current.Response.Charset = "UTF-8";
            HttpContext.Current.Response.AddHeader("Content-Disposition", "attachment; filename=" + fileName + Utils.GetRandomString(4, 4, "0123456789") + ".xls");
            HttpContext.Current.Response.ContentType = "application/ms-excel";
            HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            HttpContext.Current.Response.Write(sHtml);
            HttpContext.Current.Response.End();
        }

        /// <summary>