Take every 7 rows

datatable
excel
uiautomation
activities

#1

Hi all,

How can I take every 7 rows in an data table and output it to a new file (for each 7 rows) ?

Thanks!


#2

Hi Jasper,

You can have a While loop and increment the index with 7. You do the loop while the index value is less than the number of rows in data table.

See attached example: Main.xaml (11.7 KB)

Regards
Silviu


#3

Hi, I need to take every 7 rows not just the first row of the 7 row.
Thanks.


#4

Hi @jasperlzx,
Here i have attached the sample file. It has the sample.xlsx file . It contains the data. The robot split the each 7 rows as a single xlsx file.

File : 7 rows.zip (29.2 KB)

Regards
Balamurugan