Hii Team,
I wanna add the values of column F and column G and paste into in column H with the column name Total.
Please suggest some solutions.
Hii Team,
I wanna add the values of column F and column G and paste into in column H with the column name Total.
Please suggest some solutions.
Hi @SAHIL_PANDITA,
Use read range activity to get the data into “DataTable”
Add data Column - “Total”
use for each row activity
in side for each row use assign activity
row(“Total”)=Convert.ToInt32(row(“Employee”).ToString())+Convert.ToInt32(row(“Reserve”).ToString())
use write range activity to append the data into excel again.
Regards,
Arivu
Hii @arivu96,
In the excel file I have two “Employee” column name and “Reserve” column name.
Please check.
then you can use row(Index)
like below
row(“Total”)=Convert.ToInt32(row(5).ToString())+Convert.ToInt32(row(“Reserve”).ToString())
Regards,
Arivu
Have a look here:
It is similar to your scenario. Just change in demo xaml from other post: the skip(1) to skip(5)