How to check if a sheet exist in the excel

[manohar]

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

[alchemiz]

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…

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

Thanks,
M