Move&copy text excel

[fairymemay (noona)]

I want to copy value in row net to column F (red color).
Ex. I want copy value in E10 to F8 and F9

Ex data.xlsx (9.8 KB)
Suggest me please.

[dfilipovic (Dino Filipović)]

Hello @fairymemay,

solve it with Excel Application Scope and activities available under App Integration \ Excel \ Table:

You will maybe need to install a dependency so you need to install UiPath.Excel.Activities.

Cheers,
Dino

[fairymemay (noona)]

@dfilipovic I​ can’t​ set​ row​ because​ the number of rows in each set is not the same​ (sometime​ 2​, 3​)​

[TUSHAR_DIWASE (TD)]

You can try with this ,

1. Read range
   Counter=0

2 under for each dt
Counter=counter+1
If row(0)= “net”
Read cell - “E”+counter.tostring
Write cell -“F”+ (counter-1).tostring
Write cell -“F”+ (counter-2).tostring
Else
Do nothing

This might be long process bt will work. Hope you can find shortest way also.

[fairymemay (noona)]

If​ row​s​ in​ set​ is​ not​ unstable?

[TUSHAR_DIWASE (TD)]

Sorry but i didn’t get it… Can you explain

[fairymemay (noona)]

@TUSHAR_DIWASE
I​ want​ to​ move​ value​ net​ to​ column​ F.​
After​ row​ country​ and​ Before​ row​ net.

[TUSHAR_DIWASE (TD)]

I will create small wf and share with you.

[fairymemay (noona)]

@TUSHAR_DIWASE I will waiting wf from you.