Parse/manipulate data when pasting using keyboard short keys CTRL/CMD + V

[testone740]

Hello team. I have a grid similar to this example where the first column contains row numbers. The way I populate a row with data is by copying data from MS Excel and pasting into the grid. Because the first column, ie. column A, in my Excel spreadsheet is a data column while the first column in the grid is a row index column, the grid columns are populated correctly when pasting data from Excel into the grid. See demo below.

I know how to parse/manipulate copied data when pasting via context menu so that columns in the grid are populated with the correct data. I'd like to do the same when pasting via the keyboard shortcut keys CTRL/CMD + V, but haven't figured out a way. Any help is greatly appreciated. Thanks.

Behavior of Pasting Data using CTRL/CMD + V

My MS Excel spreadsheet looks like this:

Name	Title	Date
John Doe	Admin	7/17/2024

My React Grid looks like this:

Row #	Name	Title	Date
1
Add Row

Steps taken to copy/paste

1. Copy the 2nd row (data row) from Excel into clipboard.
2. In React Grid, click on the cell header (1) to select the whole row. Then press CTRL/CMD + V to paste the copied data.

Unexpected Result

Row #	Name	Title	Date
1	Admin	7/17/2024
Add Row