Hello,

This is really interesting question. XamDataGrid does not have this functionality but it can be easily achieved with some manual coding.

Here is what I have come up for now. When you copy your row in Excel this is what follows :

char[] separators = new char[3];
separators[0] = ' ';
separators[1] = '\t';
separators[2] = '\n';
separators[0] = '\r';

            if (Clipboard.GetDataObject().GetDataPresent(DataFormats.Text))
            {
                string row = (Clipboard.GetDataObject().GetData(DataFormats.Text).ToString());
                string[] cells = row.Split(separators,StringSplitOptions.RemoveEmptyEntries);
            }

Then you take each item in cells ( which is each cell in MS Excell and give its value to the correspondent cell in the XamDataGrid.

Hope this helps,

Alex.