How to split excel rows into multiple sheets

[Suggala_Tejaswi]

Hi Everyone,
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

[supermanPunch (Arpan)]

Hi @Suggala_Tejaswi ,

Could you maybe check the below post :

Split the output data table into smaller data table which contain 50 rows per data table

can be done with skip take: in the combination with copytodatatable split results are datatables: In Additiona to above find a compacted variation: Assign Activity: SegmentSize | Int32 = 50 Assign Activity: NoOfSegments | Int32 = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize)) Assign Activity: TableList | List(Of DataTable) = Enumerable.Range(0,NoOfSegments).Select(Function (x) dtData.AsEnumerable.Skip(x*SegmentSize).Take(SegmentSize).CopyToDataTable).ToList() For each…

[Anil_G (Anil Gorthi)]

@Suggala_Tejaswi

You can use copy paste range activity in a loop by changing the source range inside the loop

https://docs.uipath.com/activities/docs/copy-paste-range-x

cheers

[GouthamVijay]

Hello,

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

Br.