ASP.Net Download Data in Excel File without using interop.

ASP.Net  Download Data in Excel File  without using interop.
Use following code to download data as excel. First you should bind your data to gridview .

Sub saveExcel()
        ' Change the Header Row back to white color
        GridView1.HeaderRow.Style.Add("background-color", "#FFFFFF")

        ' This loop is used to apply stlye to cells based on particular row
        For Each gvrow As GridViewRow In GridView1.Rows
            gvrow.BackColor = Drawing.Color.White

            If gvrow.Cells(4).Text = "True" Then
                gvrow.BackColor = Drawing.Color.Yellow
                'For k As Integer = 0 To gvrow.Cells.Count - 1
                '    gvrow.Cells(k).Style.Add("background-color", "#EFF3FB")
            End If


        Response.AddHeader("content-disposition", "attachment; filename=GridViewToExcel.xls")

        Response.ContentType = "application/excel"

        Dim sWriter As New System.IO.StringWriter()

        Dim hTextWriter As New HtmlTextWriter(sWriter)



        lblMsg.Text = "Excel created"


    End Sub

- Written By 
Vinod Kotiya


Most Viewed Post

solution for facebook waiting

Connect Sony XPLOD MEX-BT2500 Bluetooth CD Receiver with ur mobile

Crystal Report : Show data horizontally (Left to right) i.e. columns as rows

Google+ Followers