Is there anyway to check whether an Excel file is password protected or not?

I want to create a workflow for checking whether a given downloaded file is CSV or excel after that I want to check if it is password protected or not. Please provide a solution for this or share a xaml file if u have any.

1 Like

Hi @Asmit_Anand1,

Refer this post

Hi, I know i can handle password protected excel file using excel application scope but i want to know how to check a whether it is password protected or not? Because i will get a random excel sheet from a client it may be password protected or may be not.


Use Read Range inside Try, If it throws Exception by stating locked, then you can use Password in Catch block in the Read Range Activity Once Again.