ASP.NET导出excel

        //取到数据    DataSet ds = SmsS.SmServerSetExcel(this.StartTime.SelectedValue.Value.ToString("yyyy-MM-dd"), this.EndTime.SelectedValue.Value.ToString("yyyy-MM-dd"));
        DataTable dt = ds.Tables[0];
        StringWriter sw = new StringWriter();
        //EXCEL显示的列头名
        sw.WriteLine("手机号\t内容\t发送时间");
        //读取数据
        foreach (DataRow dr in dt.Rows)
        {
            sw.WriteLine(dr["MoBiLe"] + "\t" + dr["MsgContent"] + "\t" + dr["CreateDate"]);
        }

        sw.Close();
        Response.AddHeader("Content-Disposition", "attachment; filename=Sms.xls");
        Response.ContentType = "application/ms-excel";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        //输出
        Response.Write(sw.ToString());
        Response.End();