Please Help... How do I freeze the heading row in a bound GridView?

Please Help... I need to freeze the heading row in a GridView.

I am utilizing the GridView in a routine that exports the contents of a DataTable to HTML, in Excel format.

Before I render the grid to HTML, I wanted to do some cell formatting , hoping that these customizations are then reflected in the exported XLS.

Here is my routine:

------

 Sub ExportSpreadsheet(dtExport As DataTable, strExportPathAndFilename As String)

   
        Dim gvReport As New GridView()

        gvReport.AllowPaging = False

        '-- Load the GridView
        gvReport.DataSource = dtExport
        gvReport.DataBind()

        gvReport.HeaderRow.BackColor = Color.LightGray


        For Each gvRow As GridViewRow In gvReport.Rows

            For Each gvCell As TableCell In gvRow.Cells

                If gvRow.RowIndex Mod 2 = 0 Then
                    gvCell.BackColor = Color.White
                Else
                    gvCell.BackColor = Color.AliceBlue
                End If

                gvCell.Wrap = False

                If IsDate(gvCell.Text) Then
                    gvCell.HorizontalAlign = HorizontalAlign.Center
                End If

            Next

        Next

     
        Dim swReport As New StringWriter()
        Dim hwReport As New HtmlTextWriter(swReport)

        gvReport.RenderControl(hwReport)


        '-- Write XLS-file to disk
        Dim streamReport As New StreamWriter(strExportPathAndFilename)
        streamReport.Write(swReport.ToString())
        streamReport.Close()

    End Sub

-----


Can I somehow integrate freezing the heading row into my routine where I loop through the cells?

Any help in accomplishing this would be greatly appreciated.

Until I get Excel.Office.Interop installed on the server, I need to utiize this HTML to Excel solution.
It is not perfect, but at least it gives my Users the immediate benefit of getting their data into a spreadsheet.

Many Thanks,

Nelson