Bot which reads this excel generates a new excel which consists of columns (item, total units,total unit costs, total.) e.g. for item "DESK" it gives only one row for it which has sum of its total unit, total unit costs and total

Help Studio
, ,
1

write a UI PATH bot which reads this excel, parse it and generates a new excel which consists of columns (item, total units,total unit costs, total.)
e.g. for item “DESK” it gives only one row for it which has sum of its total unit, total unit costs and total.
New Excel will have five rows for five items with sums of value.

2

@faisal.ahmed Can you Please Explain the Proces what you are trying to do :
You can Explain your process by providing these 3 Step Information :

  1. What is the Input Data?
  2. What Operations you want to perform ?
  3. The Output Data you Expect.

Screenshots / Excel Files would be Appreciated.

3

image
image490×529 30.1 KB

4

this is my excel file i need to calculate the rows according to each item… for example desk is an item so i need to calculate desk units,total unit cost and total and write them in new excel file in one row…now they are in different rows…

5

@faisal.ahmed Can you Check this Workflow :

I didn’t check if this works with sample files :sweat_smile: , But keeping in mind the Structure and Column names I have Created the workflow. Provide the Excel File Path and the Sheet names in Read Range and Write Range Activity. This Should work.

Revert back if you get any errors while executing.

GroupByAndSum.zip (1.5 KB)

1 Like
6

okay thank you so much…

1 Like