How to freeze the header row in an Excel spreadsheet exported from ASP.NET

I’m exporting an ASP.NET gridview to Excel using the following function. The formatting is working really well, except I need to freeze the header row in Excel on the export. I’m really trying to avoid using a 3rd party Excel plugin for this, but unless there’s some archaic excel markup in my AddExcelStyling function.

In gridview how to use rowcommand event for a button

I am using a gridview in aspx and i have two pages that registration and details.aspx once registration completed it should goto details page in details.aspx i have kept a gridview in that GV i am supposed be use row command event for a button it should show the all the rsults for the students with the edit button as the last column for all the students i used item template for that. but in row command event i dont know the function to write if user clicking edit it should goto the edit page using the userid the id should be noon editable mode and other fields can editable.