出口GridView控件excel文件 [英] export gridview to excel file

问题描述

我有这个code
它不断给我的错误

i have this code it keeps giving me error

Protected Sub Button2_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button2.Click

    Dim response As HttpResponse = HttpContext.Current.Response()
    response.Clear()
    response.AddHeader("content-disposition", "attachment;filename=XXXXXX.xls")
    response.ContentType = "application/vnd.ms-excel"
    Dim s As System.IO.StringWriter = New System.IO.StringWriter
    Dim htw As HtmlTextWriter = New HtmlTextWriter(s)
    GridView1.RenderControl(htw)
    response.Write(s.ToString)
    response.End()
End Sub
Public Overrides Sub VerifyRenderingInServerForm(ByVal control As System.Web.UI.Control)

End Sub

误差后，我对出口点击：RegisterForEventValidation只能在

the error is after i click on export : RegisterForEventValidation can only be called during

Render(); 

和它突出这个脚本

 GridView1.RenderControl(htw)

任何建议

推荐答案

在页面级别禁用事件验证：

Disable event validation on page level:

<%@ Page Language="VB" AutoEventWireup="false" EnableEventValidation="false"  ...

不过，我会建议创建一个真正的excel文件并写二进制到流，而不是一个HTML表格。 EppPlus 强烈建议，的使用方便并支持LINQ。 （ GPLv2许可）。

But i would suggest creating a real excel file and write that binary to the stream instead of a HTML table. EppPlus is highly recommended, easy to use and supports LINQ. (GPLv2).

这篇关于出口GridView控件excel文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！