首页 > 代码库 > Linq 导出Excel

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();

 

Linq 导出Excel