Paste Data From Excel
Environment
| Product Version | 3.15.0 |
| Product | Progress® KendoReact |
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:
- Take the data.
- Transform it into JSON based on the Grid fields.
- Set that JSON array as Grid data.
This can be seen in the following example:
Example
View Source
Change Theme:
