How to check if sheet of excel file exists in all excel files from directory

[Ostap002]

I have a list of excels' file path. 

How can I check is these files contains sheet with a specific name?

I tried using FileExists() function into file path like 'C\user\blablaba.xlsx|||`Sheetname$`' but this does not work. 

[FrederikE]

When you use the Input Tool with a .xlsx that has multiple Sheets, you can select "Import only the list of sheet names". Then you can put a Filter to check for a specific name afterwards. 

[messi007]

@Ostap002,

You can use the option import only the list of sheet names

And then you can use filter or formula tool to test 

Hope this helps,

Regards

[Ostap002]

@messi007 , Thank you for your reply,

But I can't import list of sheet names because i use Directory input and I want check all the files from folder, not only one)

Thanks,

Regards 

[grazitti_sapna · Accepted solution]

Hi @Ostap002, you can do this with a macro.

Use this as a macro configuration.

Then you can filter out the sheet.

Attaching the macro.

I hope this helps!

Thanks!

[FrederikE · Accepted solution]

In this case, you need a batch macro. See the attached WF.

[binuacs · Accepted solution]

@Ostap002 You need to crate a batch macro for this

[Ostap002]

Dears,

Thank you all for your solutions

Kind regards,

Ostap