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


#1

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.


#2

Hi @Asmit_Anand1,

Refer this post


#3

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.


#4

@Asmit_Anand1

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.

Regards,
Mahesh