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