i have one gridview which I need to export it to excel ,

is there any way using VB 

I 'm using the following code in the click event of a button on the page

Response.ContentType = "application/vnd.ms-excel"

' Remove the charset from the Content-Type header.

Response.Charset = ""

' Turn off the view state.

Me.EnableViewState = False

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

' Get the HTML for the control.

' Write the HTML back to the browser.

' End the response.

Have a read of the following article (especially the last paragraph):

http://aspnetlibrary.com/articledetails.aspx?article=How-to-export-a-GridView-to-Excel
 

Hi,

Put the gridview inside the form tag i.e.

   <form id="Form1" method="post" runat="server">

        <asp:DataGrid id="DataGrid1" runat="server"></asp:DataGrid>

</form>

To Export to Excel

thanks for the reply , but I'm getting this error now

RegisterForEventValidation can only be called during Render();

any ideas  ???

Hi,

Based on my understanding, you want to export the GridView into Excel in your asp.net VB application. When you try to run it, you get the error message above.  If I have misunderstood you, please feel free to let me know.

Sometimes, we can confirm that an HtmlForm control is rendered for the specified ASP.NET server control at run time using VerifyRenderingInServerForm method.

Please try to add the following code in your .aspx.vb file:

    Public Overloads Overrides Sub VerifyRenderingInServerForm(ByVal control As Control)

    End Sub

I hope this helps.

sarajuma:

RegisterForEventValidation can only be called during Render();

Hi，

For the this error message, please try to set the EnableEventValidation to false. For example:

<%@ Page Language="VB"  EnableEventValidation="false" CodeFile="Default8.aspx.vb" Inherits="Default8" %>

I hope this helps.

try this

Dim htmlWrite As HtmlTextWriter

Response.Charset = ""

Response.ContentType = "application/vnd.ms-xls"

Dim strStyle As String = "<style>.text {mso-number-format:\@; } </style>"

Response.Write("<H4>") ' throw in a pageheader

Response.Write("you can put title here")

Response.Write("</H4>")

What you are doing here is basically fooling your browser to redirect this request to Excel program although generated output is HTML.

There are much cleaner ways of exporting to Excel. Check out GemBox.Spreadsheet and this web sample demonstrates CSV/XLS/XLSX/ODS/HMTL writing.

The problem is that you also need to overwrite the render() method.

See if this article helps