Divide Excel sheet

[Rammohan91 (Rammohan Banda)]

Check this,

Split Excel based on row data rows

I would like to know how I can split an excel document into multiple excel documents with the records split based on number of rows in excel. For example If I have an excel of 200 records, maximum I can only have 60 records in 1 separated excel, so there will have 200/60 = 3.33, → 4 batches of files. I have to split it through UIpath and give 4 Excel documents of 60 records each as Output. (The last one is 20 rows)

How to Copy one excel file data to another excel file with different sheet name

i have one excel file(expense1) in which 30 data is there.Now i want to copy data from “expense1” file into another excel file(expense2) in such a way that each sheet of “expense2” file contains 10 per sheet. like sheet1 will contains 10 data, sheet2 will contains 10 data, sheet3 will contains 10 data of expense2 file from expense1 file. How to achieve this using loop?

Thanks,
Rammohan B.