Hi
I would like to have the functionality of after copying selected cells by mouse in Excel, when I paste into the Xamdatagrid, the cells in the Xamdatagrid should be linked to the cells in Excel. (When I make changes in the Excel sheet, the Xamdatagrid should update as well.)
I'm wondering if Xamdatagrid can do that. Please provide example to show how to do that.
Thank you!
Sincerely
Hongfei Li
Hi Rob
I have already implemented this by using Microsoft.Office.Interop.Excel and my own class.
Thanks for your reply!
Hongfei
Hi Hongfei,
It's definitely possible to copy cells from Excel and paste them into the XamDataGrid. This is currently built into the XamDataGrid so all you really need to do is set the AllowClipboardOperations property in the FieldLayoutSettings. This will give you automatic copy/paste to and from Excel. http://help.infragistics.com/NetAdvantage/WPF/?page=xamDataPresenter_Enable_Clipboard_Operations.html
For linking the cells in the XamDataGrid to the cells in Excel, this has been determined to be a new product idea. I have sent your product idea directly to our product management team. Our product team chooses new product ideas for development based on popular feedback from our customer base. Infragistics continues to monitor application development for all of our products, so as trends appear in requested features, we can plan accordingly.
We value your input, and our philosophy is to enhance our toolset based on customer feedback. If your feature is chosen for development, you will be notified at that time. Your reference number for this product idea is PI12070038.
Let me know if you have any questions on this matter.