首页 > 代码库 > 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
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。