aquil said:

I am exporting Xamdatagrid to Excel. Changing the value of cells and adding new rows. I just see paste back happening from Excel to XamDataGrid only for the rows in the grid. I also want new rows from Excel pasted to Grid. Is this possible?

The grid will only update existing records or insert new records; it will not do both. The latter only occurs when the add record is the active record and you are not in edit mode. So the user could select the new data they typed into excel, activate the add record and paste and new records will be inserted for the data in the clipboard.

I have the same issue. When copying from Excel i do not want to modify existing records. I would like to add new Records and fill these with the values copied from Excel.

I tried intercepting the clipboardpasting event but  the event contains only the records selected from the grid.

 

How can i Solve this problem?