How to check can open file excel?

Help Activities
, ,
1

Hello.

I have file excel with protect sheet.
I want to check can open file or not.

If not open it alert : The provided password is in correct.

Please guide me for solve it.
Thank you

2

Hi @Stef_99

Use Try Catch activity…Place the Read Range Workbook activity in Try block…

A UiPath workflow using a Try-Catch block to read data from an Excel file and display any exceptions in a message box. (Captioned by AI)
A UiPath workflow using a Try-Catch block to read data from an Excel file and display any exceptions in a message box. (Captioned by AI)1147×618 28.9 KB

Regards,

1 Like
3

Use the password property in the use excel activity while opening

image
image1445×578 72 KB

1 Like
4

Hi @Stef_99

Since you’ve protected the sheet and not the file, You could use the Unprotect Sheet Activity with the password. and surround it in a try catch. If the password is incorrect, it would go to Catch block.

The Flow

A structured workflow in a software automation tool for handling an Excel file, with sections for process scope and error handling. (Captioned by AI)
A structured workflow in a software automation tool for handling an Excel file, with sections for process scope and error handling. (Captioned by AI)464×441 11.6 KB

The Try Catch will have:

This image shows a section of a workflow in an automation tool, specifically a Try-Catch block attempting to unprotect an Excel sheet with a specified password and logging a message if the attempt fails. (Captioned by AI)
This image shows a section of a workflow in an automation tool, specifically a Try-Catch block attempting to unprotect an Excel sheet with a specified password and logging a message if the attempt fails. (Captioned by AI)365×436 13.3 KB

If this solves your issue, Do mark it as a solution.
Happy Automation :star_struck:

1 Like
5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.