Hi! Good Afternoon Everyone

[mohammed_zain]

I am trying to get the output in my excel sheet. The bot should write result in third column. Please with the attached screenshot below for your reference.

The final output should be like this in Result Column:
Zainul1
2Abdul
MohdZainul
7
77

Thanks,
Mohd

[Srini84 (Srinivas)]

@mohammed_zain

Check as below

testDT.rows(index).Item("Result) = cint(row(“Col1”).ToString) + cint(row(“Col2”).ToString)

Else

testDT.rows(index).Item("Result) = row(“Col1”).ToString + row(“Col2”).ToString

Place a write range outside the foreach and it will get as you expected

Hope this helps you

Thanks

[mohammed_zain]

Actually all the addition should be written one by one row.

Thanks,
Mohd

[mohammed_zain]

Values should be added write in result column. Like below

7
77

Thanks.

[pravin_calvin (pravin kumar)]

Hi @mohammed_zain

Please check out with this Xaml
Main.xaml (21.5 KB)

Mark it as solution

Thanks
Happy Automation!

[mohammed_zain]

Thanks a lot bro

Thanks.