Forum Discussion

manohar's avatar
manohar
Contributor
5 years ago

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

excel
solution

1 Reply

  • alchemiz's avatar
    alchemiz
    Contributor III
    5 years ago

    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