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();
上一篇:如何让django模型中的字段和model名显示为中文


下一篇:S3C2440移植linux3.4.2内核之支持YAFFS文件系统