Check if excel file is corrupt or not before using excel scope activity

Help
1

Hi,

I’ve tried to use the try and catch activity to recognise if the excel activity fails to open the excel file due to file being corrupted. How it works is it loops through a folder and opens a file via scope activity but doesn’t work well in the try and catch activity because there’s no continue on error option and when it attempts to open the file the error stays in place then. I want to be able to send an error message and ignore the rest of tasks if the file is corrupted. Any suggestions please?

2

Can you please try continue activity inside for each loop

Foreach loop inside put try catch once u got error catch block execute and inside catch block put continue activity

1 Like
3

@ciaramkm

What was the error when you place Try and Catch to Excel activity

Thanks

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.