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.
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.