生存Excel

       #region 生存Excel
        /// <summary>
        /// 将数据导出成为xls文件
        /// </summary>
        /// <param name="dt">数据表</param>
        /// <param name="resp">响应文件</param>
        public static void CreateExcel(DataTable dt, HttpResponse resp)
        {
            if (dt == null || dt.Rows.Count == 0)
            {
                resp.End();
                return;
            }
            resp.Clear();
            resp.ContentType = "application/ms-excel";
            resp.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
            resp.AppendHeader("Content-Disposition", "attachment;filename=" + Mltm.Common.Helper.RandomHelper.GetSystemID() + ".xls");
            string colHeaders = "商品货号\t试穿类别ID\t关键字\n";
            resp.Write(colHeaders);
            //逐行处理数据
            string ls_item = "";
            DataRow[] myRow = dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的
            foreach (DataRow row in myRow)
            {
                ls_item = row["ProductModel"].ToString().Trim() + "\t"
                + row["SortID"].ToString().Trim() + "\t"
                + row["TagList"].ToString().Trim() + "\n";
                resp.Write(ls_item);
                ls_item = "";
            }
            resp.End();
        }
        #endregion