Take one by one row

i have no of rows in excel
i want to take one row and paste it into another excel1
then
i want to take 2nd row and paste it into another excel2
i want to take 3rd row and paste it into another excel3

and so on

Hello @Ananya1

I think you can use Read Range for this task…

  • Use read range to read the full sheet into a datatable
  • Use a For Each Row activity to loop through each row in the datatable
  • Within the loop, have a row number variable that increments by one in each iteration
  • Use write cell activities which you can allow writing each value individually in the respective cell. To Identify the cell row, use the increment variable we introduced above.
3 Likes

Could u plz share workflow?

Hello @Ananya1

You can use Read Range activity and For each row activity for this case

For workflow design could you confirm every time need to create New Excel File/Sheet or do u have already stored excel files.

Cheers @Ananya1
Happy Deepavali

new excel sheet

Hello You can use this:

Excel scope (open the excel to be read)
For each activiity -> read range activity and store result in a datatable
then
for each row activity (of the datatable)
write in excel (but the the name of the excel should be a dynamic variable- Excel name:
count =0
“Result”+count.tostring+".xlsx"
Write your data,
Count=count+1

Cheers,
Vincent

could u share workflow

Hi @Ananya1,

Can you please share your excel sheet?

Thanks & Regards,
Apurba

Capture

Hi @Ananya1,

I’m attaching a .zip file, where you can find the solution. Please change the paths as required.
Forum(Ananya1).zip (19.2 KB)

Thanks & Regards,
Apurba

1 Like

Thank You

Hi @Ananya1,

Always most welcome.:slightly_smiling_face:

Thanks & Regards,
Apurba

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.