Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in RPA by (5.3k points)
recategorized by

I would like to know how I can split an excel document into multiple excel documents with the records split equally. For example If I have an excel of 200 records I have to split it through UIpath and give 2 Excel documents of 100 records each as Output.

1 Answer

0 votes
by (9.5k points)

Try adopting the following steps: 

  1. Read the Excel file to a data table.

  2. for each row the data table and put the row value to 1. new data table

  3. check if your row number ( counter ) is > than datatable.rows.count/2. If yes, put the res on 2. new datatable.

  4. Save both new datatable in 2 difference Excels files

Related questions

+1 vote
1 answer
0 votes
1 answer
asked Jul 4, 2019 in RPA by Abhishek_31 (12.7k points)
0 votes
1 answer
0 votes
1 answer
asked Jul 10, 2019 in RPA by noah kapoor (5.3k points)

31k questions

32.9k answers

500 comments

693 users

Browse Categories

...