Sum of Column in excel and paste in another column

[SAHIL_PANDITA]

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.

[arivu96 (Arivazhagan A)]

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

[SAHIL_PANDITA]

Hii @arivu96,

In the excel file I have two “Employee” column name and “Reserve” column name.
Please check.

[arivu96 (Arivazhagan A)]

then you can use row(Index) like below

row(“Total”)=Convert.ToInt32(row(5).ToString())+Convert.ToInt32(row(“Reserve”).ToString())

Regards,
Arivu

[ppr (Peter Preuss)]

@SAHIL_PANDITA

Have a look here:

Sum of rows and fill output into another column

Hi, @Soniya215, You can create a new column for the Total using “Add data Column” activity. Use For each row for the datatable and update the column value “Total” using assign activity. row(“Total”) = Convert.ToString(Int32.Parse(Convert.ToString(row(“Column1”)))+Int32.Parse(Convert.ToString(row(“Column3”)))+Int32.Parse(Convert.ToString(row(“Column4”)))) At the end of the loop, you will have the datatable as required. Happy Learning!

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