Multiply two columns of a excel table

[aksh1yadav (AKSHAY YADAV)]

@simadri

I want to calculate the “total” one by one row wise and should display the result in the same column.for

hey @simadri

You can check it out with the existing thread as well.

Excel Variable SUM Formula

Well Just a small Input Just take your Excel Data from Excel by using Excel application scope and Read range activity then fire the below linq piece of code to take the sum out of it. and add the new row in the the datatable and write it in your Excel . Every time with range you don’t have to deal with Int32 sum_col_2 = dt.AsEnumerable().Sum(function(r) r.Field(Of Int32)("Col2")) or you can use even write cell with the sum_col_2 value Sample - d…

Regards…!!
Aksh