Last post Aug 23, 2012 09:56 AM by sruthi4790
Aug 23, 2012 09:56 AM|sruthi4790|LINK
My scenario is, I am writing a Table control to an excel object using a stringWriter through Response object.
In the excel that will be created, I need to freeze the first 5 columns.
I know that we can achieve this using worksheet.Application.ActiveWindow.FreezePanes
when we are dealing direcly with an Excel object.
Can anyone please suggest how the same can be achieved in the excel created through response object.
Any help is greatly appreciated.
Thanks in advance,