Read Range Workbook: The process cannot access the file 'D:\RPA DEVEloper\make doc excel.xlsx' because it is being used by another process

hy all can you plz tell me what is wrong with this
Read Range Workbook: The process cannot access the file ‘D:\RPA DEVEloper\make doc excel.xlsx’ because it is being used by another process.

Hi @Ejaz_Ab
excel is open you need to close, or you can use excel application scope
I hope this will solve your issue.

Thanks
Akash Javalekar

@Ejaz_Ab,

It means the file is already open on your machine. If it’s on Shared drive then it’s hard to get it freed but if it’s on your local machine, use Kill Process activity to kill the excel process to get it accessible.

Hi, @Ejaz_Ab

This error is occurring because the Excel file you are reading from is open. Please close the file and try again.

the file is closed not open

@Ejaz_Ab,

Is it being downloaded or stored on Shared Drive?

yes downloaded in my pc

Try to close from task manager and try or you can use excel application scope this might work

also closed from task manager
and i am using excel process scope

@Ejaz_Ab,

Give some delay between download the file and read it.

You can also use Wait for Download activity to more accurately download the file fully and then proceed to next activities.

Thanks,
Ashok :slight_smile:

sir i wanna upload it on orchestrator queue

@Ejaz_Ab
If you are sure that there is adequate time between file downloading and reading then [Just to ensure the file is fully downloaded and not partial or corrupted] use Excel Process Scope–>Use Excel File -->Read range activity to read the data to upload to Queue.

Make sure your Use Excel File activity is configured as Read Only by changing property. This will ensure that even file is being open or used by another process, your bot will not fail.

1 Like

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