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.
Unfortunately, activation email could not send to your email. Please try again.

GridDataBoundGrid paste from Excel and add as new records

Thread ID:





67042 Aug 7,2007 06:50 PM Aug 7,2007 07:04 PM Windows Forms 1
Tags: GridControl
Daniel Salazar
Asked On August 7, 2007 06:50 PM


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 07:04 PM

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.

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.