Data table sum into a cell

datatable
excel
uiautomation
activities

#1

Hi all,

From my automation, I have many data tables that consists of data for each column.
Can I ask whether is it possible to tabulate the total amount in a single cell?

Thanks in advance!


#2

@jasperlzx,Refer this




#3

Hi, I can’t seem to get this to work and its a little confusing. Any other possible way?

Thanks!


#4

Hi @jasperlzx,
This will fix your problem.

Regards
Balamurugan


#5

Use for each row activity bro ! Then you can do many things to count the amount:

  • If you want count the number of cells, save in a variable with an assing activity the count of each row.

  • If you want to plus all the values of the whole column, save the value of each row in a variable with an assign activity -> var = convert.toInt32(row(“Name of the column”)) (I suposse the value of the row its a integer) ; Plus the values in the same var each row and you will get the sum of all rows in the column.