Print |Content-Type:application/vnd.ms-excel|Print |Content-Disposition:Attachment; filename=“Change Requests By Control Number All Data.xls”|
I am using above code to export data to excel on web browser.
I want to lock the header of Excel file. Can some one please help me to locking the header. Thanks.
Ravi
Subject: Export to Excel on Web Browser
I’m not familiar with your method of XLS creation, however, the actual command for Excel to lock a portion of the window is:
ActiveWindow.FreezePanes = True
What you need to do is ensure that the row BELOW the portion you want to freeze is selected.
I tend to create Excel sheets using the following method:
However I have just read an interesting article on creating sheets using html, negating the need to have Excel installed on the machine running the code. I have no idea how you’d lock the header using that method though.
Using the code above should be enough to allow you to lock your header