How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

Question

I want to read an excel file which have 2 columns with a few rows (integer values). I need to add a 3rd column in the excel and find the sum of the 1st 2 columns in that 3rd one. need to do this in UIPATH. Please help me

Answer 1

One way to go about the problem would be to use DataTable. So you first read your Excel file by using an Excel Application Scope activity with Read Range, then for each row read, you use an Assign activity to get the sum of row(0) and row(1), the values of the first and second items in the row, and save it to a variable; lastly, write the value in this variable back to the Worksheet at the next column at ("C" + rowNumber) e.g. C1, C2, C3. hope this helped