Title: Error opening Excel file in Use Excel File activity – UiPath Studio
Hi everyone,
I’m new to UiPath and currently trying to build a simple Excel automation in UiPath Studio. My workflow structure is:
Use Excel File → Append Range
The Excel file I am trying to use is:
C:\Users\Maitree Sharma\Documents\UiPath\Excel reports consolidation\Daily Reports.xlsx
However, when I run the workflow, I get the following error:
“Error opening file C:\Users\Documents\UiPath\Excel reports consolidation\Daily Reports.xlsx. If the file is encrypted, provide a password when the Excel password dialog is displayed.”
I also see a message saying:
“Current settings require file to be open in Excel to browse contents.”
What I have already tried:
- Closed Excel completely and ran the automation again
- Opened the file manually and clicked “Enable Editing”
- Used the folder picker instead of typing the file path
- Ensured the file is not password protected
I am using Automation Developer profile in UiPath Studio Community Edition.
Could someone please help me understand why UiPath cannot open this Excel file?
Thank you!
Hi @maitreeesharmaa
Try using append range workbook activity instead of use Excel and append range activity, this will help to perform the action if the current excel is not open as well
@maitreeesharmaa
To get the design time help to select the sheets, ranges etc, make sure you are passing the actual file path. With variable assigned to filepath won’t be able to help you in design time as the variable value gets initialized at run/debug time.
Once you pass the filepath in Use Excel File activity, you will be able to see the sheets and indicate in excel.
Hi, I did try that and this was the output.
Hello, I did specify the file path, but recieved the same error as before when selecting the indicate in excel button. The file is not encrypted, however I’m still facing the same issue.
@maitreeesharmaa
Try keeping the excel file at another location like C drive or another drive than the user profile folder.
@maitreeesharmaa
What’s the output showing in image could you show it clearly
Fixed the issue, I hadn’t installed the correct dependencies. Thank you for your help.
It couldn’t find the file, but I fixed the issue by installing the required dependencies. Thank you for your help.
