web c# 内容输出为Excel

UsersDAL usDAL = new UsersDAL();
        DataTable dt = usDAL.GetDataTable(where);
        StringWriter sw = new StringWriter();
        sw.WriteLine("自动编号"t姓名"t电话"temail"t地址"tQQ"t身份证"t中奖等级"t中奖日期"t状态"tIP");
        foreach (DataRow dr in dt.Rows)
        {
            string state = (bool.Parse(dr["state"].ToString()) == true) ? "审核" : "未审核";
            sw.WriteLine(dr["uid"] + ""t" + dr["name"] + ""t" + dr["phone"] + ""t" + dr["email"] + ""t" + dr["adress"] + ""t" + dr["qq"] + ""t" + dr["idcard"] + ""t" + dr["rate"] + ""t" + dr["luckday"].ToString() + ""t" + state + ""t" + dr["ip"]);
        }
        sw.Close();
        Response.AddHeader("Content-Disposition", "attachment; filename=data.xls");
        Response.ContentType = "application/ms-excel";
        Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
        Response.Write(sw);

        Response.End();

-----------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------

-----------------------------------------------------------------------------------------------------------------

string fileName = page.Server.MapPath(System.DateTime.Now.ToString("yyyyMMddhhmmss") + System.DateTime.Now.Millisecond.ToString() + (new Random()).Next(0, 1000).ToString() + ".xls");
            FileStream fs = new FileStream(fileName, FileMode.CreateNew, FileAccess.Write, FileShare.None);
            StreamWriter swFromFile = new StreamWriter(fs, System.Text.Encoding.GetEncoding("gb2312"));
            
           swFromFile.WriteLine(fileValue);//要写入的数据         

            swFromFile.Flush();
            swFromFile.Close();

            page.Response.Clear();
            page.Response.ClearHeaders();
            page.Response.Buffer = false;
            page.Response.ContentType = "Application/x-msexcel";
            page.Response.AppendHeader("Content-Disposition", "attachment:filename=" + page.Server.UrlEncode(System.IO.Path.GetFileName(fileName)));
            page.Response.WriteFile(fileName);
            page.Response.Flush();
            File.Delete(fileName);
            page.Response.End();

原文地址:https://www.cnblogs.com/jiangchongwei/p/1305626.html