I need sum of each row specific columns. End result needed is.
Sum = DT.Rows(0)(2)+DT.rows(0)(3) = 7
Sum = DT.Rows(1)(2)+DT.rows(1)(3) = 8
Sum = DT.Rows(2)(2)+DT.rosw(2)(3) = 6
Here you go a sample of your scenario,
check the excel file before and after running the xaml
you can get the total value in the last row for each column as you expect sum.zip (8.7 KB)
Run the xaml and you will get the sum value
Kindly try this and let know buddy whether this works or not
Cheers @reddysrs
No worries
what is your studio version buddy @reddysrs
fine
go to manage pacakages and open project dependencies tab in left side
once opening, if your version is 19.4 or something update the version of uipath.system.activities and uipath.uiautomation.activities and uipath.excel.actvities to that updates
or
if your version is 18.3 or something try to update the version of the above mentioned activities to that update version by clicking on this and these are versions
kindly update the package to these versions and see in the design panel you can see the activities for sure
kindly choose the version of all the packages you have in your project dependencies as per the above image mentioned package versions…
Then you can see the activities involved in the workflow
Cheers @reddysrs
I have found an another way @Palaniyappan by using for loop and assign
Dbsum = dbSum+Convert.ToDouble(row())+Convert.ToDouble(row(2)) where DBsum is a variable type of double.
Once I get the sum assigned to row I needed to. Thanks for all the help so far.
