Showing copied data in Infragistics wingrid

I'm using Infragi开发者_如何转开发stics wingrid in my C# winforms app. I need to be able to copy column values from an excel sheet and paste it in this datagrid.The grid should show these new values in the cells.How do I achieve this?What code changes would be required?

I tried it and only one cell value gets updated.

Thanks.

In InitializeLayout do:

e.Layout.Override.AllowMultiCellOperations = AllowMultiCellOperation.All;