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

[Asmit_Anand1 (Asmit Anand)]

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.

[akila93]

Hi @Asmit_Anand1,

Refer this post

Excel Locking and Unlocking

Hello. In principal you have a password option in Excel application scope that can help you work with password protected Excels. If you don’t want the Excel to be showing while the robot is working you can use the File Access Activities (those under System->File->Workbook) or Uncheck the visible property If you want to enable protection on a Excel during the process I think the simplest way is to create a VBA Macro that locks the Excel. For that you can check out this link Password Protect an …

[Asmit_Anand1 (Asmit Anand)]

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.

[MAHESH1 (MAHESHKUMAR JV)]

@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