How to check if a sheet exist in the excel

hi there, trying to find a solution on how to find a sheet exists in an excel file. Goal is if the sheet doesnt exist, then it will create the sheet in the excel else it should append to the existing sheet.

Any help is greatly appreciated.

Thanks
Manohar

Hi Manohar,

Have you tried trapping it in the error view??? its basically doing a try catch… put a router if $error “Sheet with the name does not exist” then create the sheet…

image

If it didn’t error then sheet is already n the excel

Thanks,
M

1 Like