I started learning UiPath a few weeks back and I’m trying to work out a rather complex task for me and I wanted to ask for your help.
I need a robot that triggers when a Excel file is created in a folder and creates a new file that contains some values from the original one. For example, I need to copy only the rows in which the name John is in the first column and sum all these values into one row.
- I created Trigger scope with File Change Trigger (with path and filename “*.xlsx”)
- For activity I wanna add Excel application Scope but Im not sure how to write Workbook path if I dont know name? For my understanding I need to declare path into variable and put it there but dont know how
- Then I would use Read Range, new Excel Application Scope, Write Range and Save Workbook
To be honest, I am little bit lost, could you please help me little bit with the workflow?
Thanks a million guys.