将gridview导出到excel文件

Question

我有这个代码 它一直给我错误，

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 只能在期间调用

Render(); 

，并且它突出显示此脚本

 GridView1.RenderControl(htw)

任何建议

Answer 1

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

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

但我建议创建一个真正的Excel文件并写入二进制到流而不是 HTML 表。强烈推荐EppPlus，易于使用并支持 LINQ。 （GPLv2）。

Answer 2

** 复制粘贴以下代码并测试您的输出 ** 在添加引用到 Microsoft Excel 11.0 对象库/Microsoft Excel 12.0 对象库/Microsoft Excel 14.0 对象库之前

        String fileName ="GVtoExcel";

        Microsoft.Office.Interop.Excel.ApplicationClass ExcelApp = new Microsoft.Office.Interop.Excel.ApplicationClass();

        ExcelApp.Application.Workbooks.Add(Type.Missing);
        for (int i = 1; i < dataGridView1.Columns.Count + 1; i++)
        {

            ExcelApp.Cells[1, i] = dataGridView1.Columns[i - 1].HeaderText;

        }
        for (int i = 0; i < dataGridView1.Rows.Count - 1; i++)
        {

            for (int j = 0; j < dataGridView1.Columns.Count; j++)
            {

                ExcelApp.Cells[i + 2, j + 1] = dataGridView1.Rows[i].Cells[j].Value.ToString();

            }

        }
        ExcelApp.ActiveWorkbook.SaveCopyAs(fileName);

        ExcelApp.ActiveWorkbook.Saved = true;

        ExcelApp.Quit();
       System.Runtime.InteropServices.Marshal.ReleaseComObject(ExcelApp);
       ExcelApp = null;