How to add numbers with excel formula dianamically

[T_Y_Raju]

Hi I have excel sheet i want add a new column As Total and add with excel formula
or any other way adding all the values of 3 columns.

Data.xlsx (8.6 KB)

[arivu96 (Arivazhagan A)]

HI @T_Y_Raju ,
please refer below video

Uipath Sum of Column in Excel

Regards,
Arivu

[lrtetala (Lakshman Reddy)]

Hi @T_Y_Raju

1.Add data column Total

2.Assign
Dt.Columns("Total").Expression = "[Salary]+[Commision]+[Bonus]"

Cheers!!

[T_Y_Raju]

assign shpuld be data row

[T_Y_Raju]

what should be the type of assign

[vrdabberu (Varunraj Dabberu)]

Hi @T_Y_Raju

Try this flow:

Output:

Regards

[T_Y_Raju]

iam using studio 2022.4.3

[vrdabberu (Varunraj Dabberu)]

Hi @T_Y_Raju

You have UiPath.Excel.Activities dependency installed you can try replicating the flow like above.

Regards

[chethan.dinnupati (Chethan Kumar DS)]

Hi @T_Y_Raju,
If you want to write the formulae =SUM(A2:C2) instead of adding manually A2 + B2 + C2.
It is necessary to use the Write Cell activity. Inside Value, add your formulae and provide necessary ROW index to the formulae.

Please find the attachment solution.

AddExcelFormulae.xaml (11.1 KB)