Hey everyone, let’s say that I have 5 tabs in excel called tab1, tab2, tab3, tab4, & tab5. I would like to tell the robot to check cell A1 in tab1, and if it’s empty paste data. Else check tab 2 cell A1, if empty paste data, else check tab3 cell A1… and so on. Is there an easy and fast way to do this with UiPath?
You can easily do it with excel activities.
→ Take an use Excel file activity and provide the path of the Excel file.
→ Insert for each excel sheet activity to iterate each sheet in the Excel.
→ Use read cell activity to read the A1 cell in each sheet and store in a variable called A1_Value
→ Take an If condition to check it is empty or not.
Not String.isnullorempty(A1_Value.toString)
→ In then block insert the write cell activity to write the input data into it.
→ Don’t place any activity in else block.
Check the below workflow for better understanding,
Hope it helps!!