Question

visual basic .net 将GridView表中的数据导出到excel

怎样将visual basic .net 2005中GridView表中的数据导出到excel中，具体步骤和编码。谢谢

Answer 1

Public Shared Sub Out(p As Page, c As Control)
p.Response.ContentEncoding = System.Text.Encoding.GetEncoding("UTF-8")
p.Response.Charset = ""

p.Response.ContentType = "application/vnd.ms-excel"
p.EnableViewState = False

Dim tw As New System.IO.StringWriter()
Dim hw As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(tw)

p.Response.AppendHeader("Content-Disposition", "attachment;filename=" & HttpUtility.UrlEncode("汇总报表.xls", System.Text.Encoding.UTF8))
c.RenderControl(hw)

p.Response.Write(tw.ToString())
p.Response.[End]()

End Sub

这是一个类 直接引用就可以了

Answer 2

嗯是的 楼上说的对