Exportar un Grid a Excel

[siannah]

¡Hola!

Esto te podrá ayudar...

Código:

Private Sub btnGeneraExcel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnGeneraExcel.Click
        Response.Clear()
        Response.AddHeader("content-disposition", "attachment;filename=NombreArchivo.xls")
        Response.Charset = ""
        Response.Cache.SetCacheability(HttpCacheability.NoCache)
        Response.ContentType = "application/vnd.xls"
        Dim stringWrite As System.IO.StringWriter = New System.IO.StringWriter
        Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)
        gridMov.RenderControl(htmlWrite)
        Response.Write(stringWrite.ToString())
        Response.End()
    End Sub