How to add values of each column and make these total of all columns as new row after all data in that excel sheet

Help
1

I have an excel with 5 columns, where 4 columns are integer variable. whereas 1 column is of type string. Now I need to find sum of all integer columns and add total of each column.
eg:
sl no name m1 m2 m3 m4
1 aaa 23 43 23 44
2 bbb 12 54 32 11

Total 35 97 55 55 (This row is which I want)

can anyone please help me

2

Hi @rifnanahas

You can use this custom activity to easily do this…

Use the datatable consolidate activity to sum up the data. A user guide is also included in the link.

https://go.uipath.com/component/datatable-plugins