I have a project to fill out a form, the form is filled with excel data. The robot will loop according to the data in Excel. If one of the Excel columns is filled in but the data is not in the website form. The robot should have continued with the next data, but instead the robot experienced an error and stopped. I have succeeded in solving this problem.
But is it possible if the robot also does not continue processing other sequences because the data has been detected as empty in the previous sequence, then there is no need to carry out the next process?
How do you get the robot to move on to other data?
Read Excel Data: Use Excel Application Scope to specify the Excel file and Read Range to read the data into a DataTable variable.
Loop Through Excel Data: Use For Each Row activity to iterate through each row in the DataTable obtained from Excel.
Check for Empty Data: Within the loop, use an If activity to check if the data in the specific column is empty. Use the condition String.IsNullOrEmpty(row("ColumnName").ToString).
Conditional Processing: If the data is not empty, proceed with filling out the form on the website. If empty, skip to the next iteration of the loop.
Continue Processing: Ensure that the activities for filling out the form are placed inside the “Then” section of the If activity. This ensures that if the condition is met (i.e., data is not empty), the robot proceeds with filling out the form.
Repeat Steps 3-5 for Other Sequences: If there are other sequences to be processed, repeat steps 3-5 within the loop.
End of Loop: After processing each row, the loop will automatically move to the next row until all rows are processed.
If for example you are filling data from excel file and incase data comes blank in particular data Row so you can move towards next data row.
For this you can add validation by using IF condition if particular column and its value is blank then it will mail user and go to next data row simple.
For every data row IF validation will take place due to which your process will work efficiently.
I hope this will help you in effective way.
Please let me know if my solution works for you.
You must have used type into activity from subaccount sequence. So before that add a IF condition as told and you know according to condition perform activites.
If currentrow value comes blank it will go in THEN.
In then it will mail the user and will go for next loop.
In Else add DO sequence simple.
Thank you.
Please let me know if my resolution works for you.
Sorry, I can’t provide the file, only the plot. Thankyou
I have excel data like this, in the “Sub Account ID” column the data is red, meaning there is no data in the form. But the robot will still check the data on the form.
I want if the data is not there, then the data will not continue to the next sequence, if the data is there then it can continue to the next Screenshoot sequence
I want if the data is not there, then the data will not continue to the next sequence, if the data is there then it can continue to the next Screenshoot sequence
Q: Data is not there from excel right?
Anil_G
shaik.muktharvalli1
ashokkarale
Akash_Javalekar1
sudster
mohamed.shaker
Affan_Basar
lrtetala
johnom1
erkanceylan