Linq 导出Excel

　　

       var d = db.User;
            Repeater1.DataSource = d.ToList();
            Repeater1.DataBind();
            string guid = Guid.NewGuid().ToString();
            Response.AppendHeader("Content-Disposition", "attachment;filename=" + guid + ".xls");
            Response.ContentType = "application/ms-excel";
            Response.Charset = "gb2312";
            Response.ContentEncoding = Encoding.GetEncoding("gb2312");
            System.IO.StringWriter writer = new System.IO.StringWriter();
            writer.Write("我\t爱\t你\r");//这个就是设置抬头
            foreach (var item in d)
            {
                writer.Write(item.name);
                writer.Write("\t");//分列
                writer.Write(item.pwd);
                writer.WriteLine();
            }
            Response.Write(writer.ToString());
            Response.End();

 

转载于:https://www.cnblogs.com/crazyair/p/4000868.html