This is regarding splitting excel workbook into different workbooks depending on row count reaching 50 rows.
Eg . A workbook has 100 rows
Then, Excel would split the 100 rows into 2 workbooks each having 50 rows.
The trick is that it can be 2 rows to 100,000 rows workbook. It is not constant. So, im trying to find a way to count the number of rows and then a way to open a new excel and paste the rows.
Request ideas and suggestion to implement this scenario in uipath please.