I have 30k records of data in excel sheet, I want to split that excel into 6 excel worksheets, so that each work sheet will contain 5k records. How to split rows into multiple sheets.
Thanks in advance
Hi @Suggala_Tejaswi ,
Could you maybe check the below post :
You can use copy paste range activity in a loop by changing the source range inside the loop
- Count the number of records in the excel (Datatable.count)
- Divide that to 4 parts
- Read the same file by using Read Range with different ranges (4 times = 4 DataTables)
- Write that into 4 different tabs.