How to check if an excel sheet exists

[anonymous3 (non)]

Hi all,

I am creating multiple excel sheets in my process but I want to check if a specific sheet (eg sheet2) exists so that I do not overwrite the data within. How do I do so?

[monika.c (Monika Chaudhari)]

@anonymous3

check this link.

Check sheet name ( exists )

Hi All, I have a script that process xls files, I want to process only files that has a specific sheet and not process the rest . Is there way to check if a sheet exists in the file it opens. I use a for each file to process the files. Thanks

Check Excel sheet exist or not

How can I check in my excel file sheet exist or not…?