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
Raghunath
190
Copy and Paste Excel data into XamDataGrid
posted

Requirement: Display empty XamDataGrid with some unbound columns, and user wants to copy/paste data from Excel into the grid and save to database.

The Excel data columns are the same as format/number as the unbound columns in the grid. 

  • Is there a sample example for this?
  • Does the grid automatically add as many rows as the excel has, when the "paste" operation is done on the grid?

  • 138253
    Offline posted

    Hello,

     

    Thank you for your post. I have been looking into it and I created a sample project for you with the functionality you want. Basically I handled the pasting command and add as many new Records as needed to the XamDataGrid. Also please note that you should have active Cell which is not in EditMode in order to have the functionality works correctly.

     

    Hope this helps you.

    XamDataGridClipboard.zip