Forums Ultimate UI for WPF
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
Dave
785
Locking Columns in an Exported Excel Spreadsheet
posted

Hello All,

When exporting a XamDataGrid to Excel, I'd like the created spreadsheet to have the first two columns locked in place. They need to remain visible as the user scrolls to the right. Is this possible?

Thanks,
Dave

 

  • 138253
    Offline posted

    Hello Dave,

     

    It has been a while since you have made your post, in case you still need support I will be glad to assist you further. I suppose the other community members can benefit from this answer as well. So I have been looking through your post and I created a sample project for you, where I set the first two columns of the sheet to be frozen through code in the application immediately after I export the XamDataGrid to it.

     

    Feel free to write me if you have any other questions.

    XamDataGridExcelExportFrozenPanes.zip