I’m working on a project for class and am very new to this platform so any help is greatly appreciated in advance. I’ve had to projects similar but all were only for one excel file, for this one there’s 2 files with a client code in a cell (E8) and from that I need to get a discount price to input to F18 in each sheet.
I know I need to “Read Cell” the client code in cell E8, then Use Browser (to put the client code and receive the discount amount. Step 3 is to the “Type Into” activity to put the code into the box. Then to “Click” the arrow on the website. Then “Get Text” to get that discount amount shown on screen. The final step is to “Write Cell” to input the amount to F18.
My dilemma is that I need to do these steps for both sheets, they have different discount amounts, therefore need to input as such. The above is 6 activities and 7 is the max requirement so what is one additional step that would completely loop the steps for each sheet.
Thank you again!
Before reading cell E8, use the activity for each excel sheet and put all your steps inside that loop.
This way same set of steps will get executed for each sheet in workbook.
Hope this helps.
@Savannah_Parks ,
Use For Each activity to go through both sheets. Put your 6 steps inside it so they run once per sheet and write the correct discount to F18.
Thanks
Hello @Savannah_Parks ,
I think you are more talking on workflow analyzer rules inside the Loop! Great that you are looking at best practices. Please create an separate XAML (workflow) for all the actions inside the browser and Invoke so all these steps inside the browser will become one activity (invoke workflow file) inside your loop and your activities count will get reduced.
Thanks,
Karthik