Detecting if an excel file is emty

studio

#1

Hello,

i’m looping through a directory: and opening excel files where theirename contain the jey world “Extracted” but some times there is excels where they are empty, so ectivities after the read range failed, because the sheet does not existe.

how to do verification if the exel i empty or not befor opening it in an excel application scope


#2

Hello @abdel,

You can put the excel scope in the try catch activity and in the catch activity write a suitable log message,
So when a sheet is missing or excel is blank, an exception will be generated and a log message will be written but you’re workflow will continue to run!

Regards,
Rishabh