Check the exitance of a sheet in Excel file

[yuanlu]

I have an Excel file with multiple sheets, existence of those sheets are random. If a sheet is there, a series calculation will be perfomed based on the sheet data, if not, I wish there is a way to stop the workflow right away.

Is there a way to stop the workflow when workflow finds out a sheet does not exist like shown below? 

[atcodedog05 · Accepted solution]

Hi @yuanlu 

Here is how you can do it.

1. Use the message tool like below. What the below message tool is doing is its checking recordnumber=1 exists (which means there is at least one row in false). If recordnumber=1 stop and error at that point.

2. Configure the workflow in the runtime tab to Cancel running the workflow on error.

Hope this helps : )

[atcodedog05]

Happy to help : ) @yuanlu 

Cheers and have a nice day!

[jacob_kahn]

@atcodedog05 - thanks for the clear explanation! Really helps!

[atcodedog05]

Happy to help and share : ) @jacob_kahn 

Cheers and have a nice day!