Issue with “Get Table Range Workbook” — file locked error

Help Task Capture
1

Hi everyone,

I’m new to UiPath and learning to automate Excel tasks. I have an Excel file and I’m using the Get Table Range Workbook activity inside a Use Excel File scope. Here’s what I’m doing:

  • Step 1: Use Excel File activity and specify the Excel path with data
  • Step 2: Inside the scope, I use Get Table Range Workbook with the correct file name and sheet name
  • Step 3: Add a Message Box to show the output

However, when I run it, Excel opens (Step 1 is fine), but at Step 2 I get the error:

“Get Table Range Workbook: The process cannot access the file ‘C:\Excel\Sample.xlsx’ because it is being used by another process.”

I’ve ensured that all Excel instances are closed before starting the workflow.

Has anyone faced this issue? What could be causing the file lock, and how can I resolve it so the Get Table Range Workbook works as expected?

Thanks in advance for help!

2

@john_wich

I see issue is same .. check below

Cheers