Check if sheet of excel file exists

[KMadamba]

I am currently doing an error report and would want to catch all the files that is missing a specific sheet. This specific sheet will be my data source for another workflow, that is why I would want to filter them out so that this other workflow will not process them and will go to the error report instead.

I was wondering if there's a way to check if an excel file sheet exists.

I tried using FileExists() and then added the sheet name into the formula tool and then pass it onto a filter tool like this but this does not do the trick.

[afv2688 · Accepted solution]

Hi @KMadamba 

Are you checkin if a file you are reading has the specified sheet names? You can click while doing the loading of the file to read only the sheet names, that way you can check if every single one of them is there, doing a count or a name check value.

cheers

[KMadamba]

Thank you! This is exactly what I was looking for. 

[williamdilley]

I did this but now want to incorporate that into a conditional if statement as such, but its now working:

IF "Sheet Names" = "Data"
THEN "Tab Name is Correct" ELSE "Tab Name is Incorrect"
ENDIF

[williamdilley]

Typo, its not working.

[KMadamba]

Hi @williamdilley 

To only check if the sheet exists within a file, I used a filter tool for mine and applied formula to output the message, then union both outputs back together, like so;