Paste Data From Excel

Environment

Product Version	3.15.0
Product	Progress® KendoReact Grid

Description

I need to provide mechanism for pasting data into my KendoReact Grid, from Excel sheets.

Solution

This will require wrapping the Grid in a div element and attaching an onPaste event. Then on that event:

1. Take the data.
2. Transform it into JSON based on the Grid fields.
3. Set that JSON array as Grid data.

This can be seen in the following example:

Change Theme

Theme

Loading ...