Sum of Column in excel and paste in another column

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

1 Like

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

@SAHIL_PANDITA

Have a look here:

It is similar to your scenario. Just change in demo xaml from other post: the skip(1) to skip(5)