While following along the Introduction to Studio Web course’s activity of validating registration codes and automatically send corresponding emails based on check outcomes, I realised that my automation didn’t check any of the entries in the Excel file.
It’ll just show on the activity panel that execution successful unlike the sample provided.
I’ve taken care to ensure that all my steps are the same as the instructions.
Pls let me know if anyone know what’s the issue.
Thank you.
@YHLeow - What happens when you run the process in debug mode and step through the validation check? Does it reveal something missing or misconfiguration? Or does something else happen? Feel free to share screenshots if you need further help.
@goprisko , thanks for the response. It only shows that it was run successfully. Sharing a screenshot here, hopefully it helps with the debug.
Thanks for replying me Sanjay.
I’m going to ask very elementary questions as I’m very new to UiPath.
How do I make sure the excel file is opening correctly?
I’ve verified the range it’s reading from.
I’ve added a message box to my macro workbook and it’s taking a very long time to run.
I’ve checked my steps with the guide provided in the course and they matched. So I’m out of wits why is it not working as expected.
@YHLeow Cheers to you for asking a question that could be viewed as elementary or basic.
If your process is using the Excel Application Scope and associated Excel activities within the scope, then you could capture the output in a Data Table and visually confirm the table is not empty when running the process in debug mode. If absolutely necessary, you could run a check after each assign to confirm the variable is not empty (not recommended for production).
