Check the exitance of a sheet in Excel file

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?

Workflow

Accepted answers

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 : )

message stop.yxmd

All comments

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 : )

message stop.yxmd

Happy to help : ) @yuanlu

Cheers and have a nice day!

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

Happy to help and share : ) @jacob_kahn

Cheers and have a nice day!

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703