无需模板导出EXCEL：自动生成文件并下载

csData.CreateExcel(this.Page, rt.ds.Tables[0], "1", "外购入库page1" + strDtStart + "至" + strDtEnd + "");  //调用实例

        public static void CreateExcel(System.Web.UI.Page page, DataTable CustomerTB, string typeid, string FileName)
        {
            //Model.Model.tb_CustomerList custList = CustomerList;
            //DataSet ds = CustomerTB;
            //ds.Tables.Add((DataTable)CustomerList);
            HttpResponse resp;
            resp = page.Response;
            resp.Charset = "UTF-8";
            resp.ContentEncoding = System.Text.Encoding.Default;
            resp.ContentType = "application/ms-excel";

            resp.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(FileName, System.Text.Encoding.UTF8) + ".xls");

            string colHeaders = "", Is_item = "";
            int i = 0;

            //定义表对象与行对象，同时使用DataSet对其值进行初始化
            //DataTable dt = ds.Tables[0];
            DataRow[] myRow = CustomerTB.Select("");
            //typeid=="1"时导出为Excel格式文件;typeid=="2"时导出为XML文件
            if (typeid == "1")
            {
                //取得数据表各列标题，标题之间以\t分割，最后一个列标题后加回车符
                for (i = 0; i < CustomerTB.Columns.Count; i++)
                {
                    colHeaders += CustomerTB.Columns[i].Caption.ToString() + "\t";
                }
                colHeaders += "\n";