hi, I am having the problem like this
expense date date date
11/02/2018 12/08/2018 13/08/2018
breakfast: 100 100 100
dinner 500 500 500 .
in excel the data is like this .
i need to individual row sum the indivual expense and store it into another expense like .
name : breakfast dinner
akshay 300 1500.
which is the easy way to do this . i have done this by reading cell and adding the value of sum into another variable and then writing the value to another excel . but it will take more time for this .can any one please give the easy solution for this .
Have you gone through the UiPath training video regarding the excel activities? If not, you can go through it once to get a better understanding of using excel with UiPath.
As for this question, I’ll save you the time.
Use “Build Datatable” activity with the columns you need–name, breakfast, dinner.
From the input excel sheet, find the cell from where you need the table. Let’s say the “breakfast” row starts at A3. Use Excel Application scope and use the “read range” activity to fetch both the rows you need ie ‘breakfast’ and ‘dinner’ as a datatable.
Use for each data row to take the sum of the row values.
Use Add data row with the datatable you built earlier.
