Repeater.RenderControl导出excel问题
我使用Repeater.RenderControl导出excel时,所导出的内容全部写成一列了,为什么???例如
Repeater数据形式:
列1 列2 列3
a b c
导出excel后格式却变成一列,如下:
列1
列2
列3
a
b
c
谁能帮帮我呀??
附上代码.
Response.Clear()
Response.Buffer = True
'//设置了类型为中文防止乱码的出现
Response.Charset = "utf-8"
'//定义输出文件和文件名
Response.AppendHeader("Content-Disposition", "attachment;filename= Table_" & Name & ".xls")
'//设置输出流为简体中文
Response.ContentEncoding = System.Text.Encoding.UTF8
'//设置输出文件类型为excel文件
Response.ContentType = "application/vnd.ms-excel"
Me.EnableViewState = False
Dim myCItrad As New System.Globalization.CultureInfo("ZH-CN", True)
Dim oStringWriter As New System.IO.StringWriter(myCItrad)
Dim oHtmlTextWriter As New System.Web.UI.HtmlTextWriter(oStringWriter)
DG.RenderControl(oHtmlTextWriter)'DG为我的Repeater名
Response.Write(oStringWriter.ToString())
Response.End()
--------------------编程问答-------------------- 学习 --------------------编程问答-------------------- 还有没有没有睡觉的高手在呀?? --------------------编程问答-------------------- 自己顶自己呀 --------------------编程问答-------------------- up --------------------编程问答-------------------- 帮顶了
补充:.NET技术 , ASP.NET