Divide Excel sheet

[CamiCat]

Hello friends,
I need to divide an Excel sheet with more than 15 rows in separate Excel files .Xslx, each one of maximum 15 rows.
If you want I can attach here an example of Excel file.
Can you please help me in doing that?
Can you please attach a sample workflow?
Thank you so much dir your kind help.
Camilla

[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.

[Akash_Jain]

Hi Camicat, one way is when you do read range there is an option to specify range, you can use this option to divide your excel into multiple data table and use it further as required.

[CamiCat]

Thank you @Akash_Jain.
How is it possible to generate multiple tables with the “Read Range” activity?
Thank you so much.
Camilla

[Akash_Jain]

Hi Camicat,

One way i can think of now is,
Perform read range within loop, so the first loop data in data-table will be pushed to the excel that you want to and then clear the table and perform the activity for next set of rows in next iteration…