Hi All, I have a requirement where I have to customize the existing "Excel Renderer". So, here is my requirement. Basically, all my reports have the functonality of exporting the data to excel and the excel should have the following features enabled in it. 1) Autofilters turned on for each and every excel column 2) Column and Row freezing etc.. Could you please point me / suggest me out some resources or code snippets? Thanks, PrawinPrawin

I don't think you have too many options to csutomize an existing Excel renderer. But yes you can always refer the DeviceInfo settings for Excel to enable/disable a few features. Here it is : http://msdn.microsoft.com/en-us/library/ms155069.aspx [Excel Device Information Settings] http://msdn.microsoft.com/en-us/library/ms159836.aspx [Exporting to Microsoft Excel] Hope this helps!!Chaitanya

Hi Prawin, Just add some more information to Question2, Excel does not support Column and Row freezing after being exported. Howerver to work around the issue, you could achieve this requirement in the Excel level. For detail steps please see: Click the header row in excel Click View menu on top of the toolbar, then you will Freeze Panes Select one kind of Freeze based on your requirement. You could also refer to this link http://inpics.net/tutorials/excel2007/vis5.html If you have any concern, please feel free to ask. Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.