Forums Ultimate UI for ASP.NET Web Forms
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Sujeeth
90
Freeze cells in excel export using UltraWebGridExcelExporter
posted

Hello All,

I have used the UltraWebGridExcelExporter object to export the data to excel. In the _BeginExport event I have written the code to freeze the cells

e.CurrentWorksheet.DisplayOptions.FrozenPaneSettings.FrozenRows = 2 e.CurrentWorksheet.DisplayOptions.FrozenPaneSettings.FrozenColumns = 4 e.CurrentWorksheet.DisplayOptions.PanesAreFrozen = True

But the problem with this is that the excel panes are frozen and will not respond to the mouse scroll. We will have to explicitly use the excel worksheet scroll to scroll through the cells.

I am using Infragistics 7.3

Thanks in advance for the help.

Regards,

Sujeeth