Check if sheet of excel file exists

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.

Input

Best Practices

Help

Data Investigation

Accepted answers

afv2688

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

All comments

afv2688

Hi @KMadamba

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703