html导出excel时换行符,ASP.NET 导出到Excel时保留换行的代码

完整代码：

protected void Button1_Click(object sender, EventArgs e)

{

System.Web.HttpContext curContext = System.Web.HttpContext.Current;

// IO用于导出并返回excel文件

System.IO.StringWriter strWriter = null;

System.Web.UI.HtmlTextWriter htmlWriter = null;

// 设置编码和附件格式

HttpContext.Current.Response.Clear();

HttpContext.Current.Response.Buffer = true;

HttpContext.Current.Response.AddHeader("content-disposition", string.Format("attachment; filename={0}", "aaa.xls"));

curContext.Response.ContentType = "application/vnd.ms-excel";

curContext.Response.ContentEncoding = System.Text.Encoding.GetEncoding("GB18030");

curContext.Response.Charset = "";

// 导出excel文件

strWriter = new System.IO.StringWriter();

htmlWriter = new System.Web.UI.HtmlTextWriter(strWriter);

htmlWriter.WriteLine("标题");

// 返回客户端

GridView1.RenderControl(htmlWriter);

curContext.Response.Write(strWriter.ToString().Replace("
", "
"));

curContext.Response.End();

}

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

GridView1.DataSource = CreateDataSourceByXianhuiMeng();

GridView1.DataBind();

}

}

System.Data.DataView CreateDataSourceByXianhuiMeng()

{

System.Data.DataTable dt = new System.Data.DataTable();

System.Data.DataRow dr;

dt.Columns.Add(new System.Data.DataColumn("学生班级", typeof(System.String)));

dt.Columns.Add(new System.Data.DataColumn("学生姓名", typeof(System.String)));

dt.Columns.Add(new System.Data.DataColumn("语文", typeof(System.Decimal)));

dt.Columns.Add(new System.Data.DataColumn("数学", typeof(System.Decimal)));

dt.Columns.Add(new System.Data.DataColumn("英语", typeof(System.Decimal)));

dt.Columns.Add(new System.Data.DataColumn("计算机", typeof(System.Decimal)));

for (int i = 0; i < 8; i++)

{

System.Random rd = new System.Random(Environment.TickCount * i); ;

dr = dt.NewRow();

dr[0] = "班级" + i.ToString();

dr[1] = "学生姓名：孟子E章" + i.ToString() + "
所在班级：" + "班级" + i.ToString();

dr[2] = System.Math.Round(rd.NextDouble() * 100, 2);

dr[3] = System.Math.Round(rd.NextDouble() * 100, 2);

dr[4] = System.Math.Round(rd.NextDouble() * 100, 2);

dr[5] = System.Math.Round(rd.NextDouble() * 100, 2);

dt.Rows.Add(dr);

}

System.Data.DataView dv = new System.Data.DataView(dt);

return dv;

}

public override void VerifyRenderingInServerForm(Control control)

{ }

无标题页