We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

GridDataBoundGrid paste from Excel and add as new records

Thread ID:





67042 Aug 7,2007 10:50 PM UTC Aug 7,2007 11:04 PM UTC WinForms 1
Tags: GridControl
Daniel Salazar
Asked On August 7, 2007 10:50 PM UTC


I've been searching the forums the samples and trying to read the documentation without success. How do I place a button that allows me the contents of the clipboard, an excel worksheet to be pasted on the databound grid, but the records should be added as new records. Not paste them over the existing records.

Could you point me in the right direction?


haneefm [Syncfusion]
Replied On August 7, 2007 11:04 PM UTC

Hi Daniel,

If you want to add new row when paste data from excel, then you will have to handle the entire paste yourself. You can do this by catch the grid.Model.ClipboardPaste event and add the new row using the underlying datasource of the grid( For DataTable,use DataTable.NewRow method).Than paste the add over newly added rows in a Grid. Here is a forum thread that shows this "How to customize the ClipBoard paste technique in a Grid?".


Best regards,


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon