Enable to fetch data from excel in Excel using Excel Activity in uipath studio

Error Message
Error opening file C:\Users*\UiPath\Excel Reports Consolidation\Sales Results\Sales Results-2024-06-16.xlsx. If the file is encrypted, provide a password when the Excel password dialogue is displayed.

Extra Info
Community version License Studio 2024.10.1
Microsoft® Excel® 2016 MSO (Version 2406 Build 16.0.17726.20078) 64-bit

Hi @Vidhi_Patel

The excel file is encrypted the excel will not allow read range activity to read the excel.

Open the properties of read range activity give the password in the password field then the bot will automatically decrypt the excel and read it.

If you are using the Modern Excel activities you can give the Password in the Use excel file activity it will decrypt the excel inside of Use excel file activity you can insert excel activities to do manipulations in the excel.

Check the below image for better understanding,

Hope it helps!!

1 Like

Hi @Vidhi_Patel ,

If its password protected file please provide the password .

Regards
Sandy

How do i know that my file is password protected or not ? or where do I find pwd or how to modify , any idea about it?!

If the excel file is Input file for the process, contact your business team to check the excel is encrypted or not, if they say yes, then ask them password to do the process in the Excel file… @Vidhi_Patel

Hope you understand!!

1 Like

If you find the solution Make my post Mark as solution to close the loop… @Vidhi_Patel

Happy Automation!!

1 Like

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