How to check if excel file contains password protected sheets or cells

[yaniketz (Oleksandr)]

Hello, i have a task to check if excel file contains protected items.
I open file in excel application scope and if file requires password or file broken i get exception, so I can check it.
But how to check if file contains password protected sheets or cells?

Thank you.

[nimin (nimzz)]

Hi @yaniketz,

This may be helpful for you.

Pass either a workbook variable OR the path to a workbook as arguments in separate workflows

For the first question, about the situation whether the workbook is already opened: simply use the ‘Excel application scope’. If the workbook is not opened, UiPath will open it and execute the activities in that scope. If the workbook was already open, then it will execute the activities. In both cases you can then use the output workbook variable of that ‘Excel application scope’ activity for your next activities. For the password protected workbooks: you can use the ‘Invoke VBA’ activity to c…

Warm regards,
Nimin

[yaniketz (Oleksandr)]

Thank you.