Say there is a Repeating Grid , where the User is able to enter "n" number of Rows by clicking add button.
Say if there are 50 rows need to be added in Repeating Grid Layout. It might be difficult for the User to click the add button to edit the row. So, Having a button on the Top of the Repeating Grid, where it is configured to perform Edit in Excel can be done , so that Editing the Excel will automatically populate the Values in repeating Grid.
How to Edit a Repeating grid by adding / Updating Values via Edit in Excel Functionality just by having a button placed just near the Repeating Grid ??
It should be possible as you can add rows to a data table using the Edit In Excel button. Although I have never done this I would recommend opening up a Data Table and turning on your UI Inspector so you can see how the Pega Developers are configuring this feature. From there I would reverse engineer it to see if I could get it working in my application.