hi my friends
i want to give boot p3 and s2, for example, and boot should find me cell c4. it should first find p3 and s3 in excel and then show me the c4
=> Use the use excel file activity and give the path of the excel file.
=> Inside use excel file activity insert the for each excel row activity to iterate the excel rows.
=> Inside for each Insert an If condition and check the condition
- Condition -> Currentrow("Task").equals("p3")
=> In then block give the write cell activity to write the value in the s2 column specific cell.
=> In the range of the write cell activity give like this. - Currentrow.byField(“s2”).
Which indicates the cell which matches the p3 value and s2 column.
Hope it helps!!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.