导出网页形式的excel怎么设置单元格格式为自动换行???

[jeanso]

Response.Clear();
Response.Buffer = true;
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.Default;
HttpContext.Current.Response.ContentType = "application/vnd.ms-excel";
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + HttpUtility.UrlPathEncode("道路统计表" + DateTime.Now.ToString("yyyyMMddHHmmss")) + ".xls");
this.Page.EnableViewState = false;
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
this.Page.RenderControl(oHtmlTextWriter);
Response.Output.Write(oStringWriter.ToString());
Response.Flush();
Response.End();

-----------------
我用web常用的方法导出成excel，页面gridview设置了宽度，每一列也设置了固定的宽度，可就是导出excel会变成一行，未自动换行，有没办法啊？

[jeanso]

我希望的是生成excel，不是插入原来存在的excel文件里。如果多人读取那个excel文件插入数据，恐怕会出错吧

[wuyq11]

那就设置gridview单元格自动换行

[liumangdaheng]

定义Excel的格式,然后循环读取gridview中行列值,插入到Excel中去

[yefengzhixia]

顶了

刚建一c#群 63242231 希望有志同道合的朋友和高手加入指导

谢谢。。。呵呵呵

[Fibona]

那手动定义Excel的格式,然后循环读取gridview中行列值,插入到Excel中去

[jeanso]

up2u

[jeanso]

gridview单元格自动换行设置了的，网页显示是对的，导出成excel就不行了

[jeanso]

up2u