从DataTable导出Excel文件

/// <summary>
        /// 导出记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected void Button1_Click(object sender, EventArgs e)
        {
            string sql = "select c.UserID as '用户名',a.UserName as '姓名',b.SchoolName as '学校',b.ZhuanYe as '专业',c.Sdate as '访问日期',c.CallPage as '页面地址',a.Email as '用户邮箱',a.Telephone as '用户联系号码' from XTGL_UserVisitDetails as c left join XTGL_UserInfo as a on c.UserID=a.UserID left join Student_Info as b on c.UserID=b.UserID 
            DataTable dt = DataAccess.GetDataTable(sql);
            string path = PubMethod.GetPath("70");//服务器的文件路径
            try
            {
                ExportExcelStream(dt, HttpUtility.HtmlDecode(path + "用户访问明细.xls"));

                PubMethod.DownloadFile(Page, "用户访问明细", path + "用户访问明细.xls", ".xls");
            }
            catch (Exception)
            {
                PubMethod.ShowMessage(Page, "数据导出出错");
            }

        }

        /// <summary>
        /// 保存DataTable数据到filepath文件中
        /// </summary>
        /// <param name="table">数据源</param>
        /// <param name="filepath">文件</param>
        public void ExportExcelStream(DataTable table, string filepath)
        {
            StringWriter stringWriter = new StringWriter();
            HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
            System.Web.UI.WebControls.DataGrid excel = new System.Web.UI.WebControls.DataGrid();
            excel.DataSource = table.DefaultView;  //输出DataTable的内容 
            excel.DataBind();
            excel.RenderControl(htmlWriter);

            string filestr = filepath;
            int pos = filestr.LastIndexOf("//");
            string file = filestr.Substring(0, pos);
            if (!Directory.Exists(file))
            {
                Directory.CreateDirectory(file);
            }
            System.IO.StreamWriter sw = new StreamWriter(filestr);
            try
            {
                sw.Write(stringWriter.ToString());
            }
            catch (Exception)
            {
                PubMethod.ShowMessage(Page, "数据导出出错");
            }

            sw.Close();
        }