Back

Explore Courses Blog Tutorials Interview Questions
0 votes
1 view
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.8k points)
0 votes
1 answer
0 votes
1 answer
asked Jul 10, 2019 in RPA by noah kapoor (5.3k points)
Welcome to Intellipaat Community. Get your technical queries answered by top developers!

28.4k questions

29.7k answers

500 comments

94k users

Browse Categories

...