asp.net Winform 将GridView数据导出成Excel----求大侠帮忙

Question

1.请问有相关的代码吗？？

Answer 1

参考： http://blog.csdn.net/guwei4037/article/details/8980456

Answer 2

这是vb代码，我的系统里用的，自己改成C#代码吧
 Dim page As Page = New Page()
        Dim sb As StringBuilder = New StringBuilder()
        Dim sw As StringWriter = New StringWriter(sb)
        Dim htw As HtmlTextWriter = New HtmlTextWriter(sw)        Dim excelFileName As String = "导出文件名" + ".xls"
        '设置格式保存Gridview中的0
        Dim style As String = "<style>td{ mso-number-format:\@;} </style> "        Dim Form As HtmlForm = New HtmlForm()
        'GridView_Excel是前台GridView的ID
        GridView_Excel.EnableViewState = False        page.EnableEventValidation = False        page.DesignerInitialize()        page.Controls.Add(Form)
        Form.Controls.Add(GridView_Excel)        page.RenderControl(htw)        Response.Clear()
        Response.Buffer = True
        Response.ContentType = "application/vnd.ms-excel"
        Response.AddHeader("Content-Disposition", "attachment;filename=" + _
                    HttpUtility.UrlEncode(excelFileName, Encoding.UTF8).ToString)        Response.Charset = "GB2312"
        Response.ContentEncoding = Encoding.Default
        '保存0
        Response.Write(style)
        Response.Write(sb.ToString())
        Response.End()