Paste As Rows property for Grid
This property enables pasting data from Excel Sheet to Grid. We can quickly update or insert mass data from Excel to Grid
Select the Row and Column for which you want to paste data. Now go to column header and click on the icon() to see a menu. Hover on 'Paste As Rows' menu item to see a TextArea where you can paste the data (Use Ctrl+v).
Data will be inserted from selected row onwards. If no row is selected then it will insert from 1st row onwards. If we copy more rows than grid rows then it will automatically create new rows.