Error while trying to read a range from excel

Build IT Automation
#1

Read Range: The process cannot access the file ‘****CustID_1111.xlsx’ because it is being used by another process.

*** is the path.
The excel is not open but this error is thrown. Does anyone have an idea why this is happening?

Background of what I am trying to achieve : I am trying to read some entries from an excel and I want to add these to a queue, pick the data from queue & search relevant data from a website and save corresponding data to another excel.

#2

Hi @Manjari_Ramadas

Check whether the excel file is corrupted or

Check the excel activitiy is in latest versions

Nived N

Happy Automation :slight_smile:

#3

Thanks for the quick response @NIVED_NAMBIAR.
Excel is latest version not sure if its corrupted for any reason though. Let me check.

1 Like
#4

Hi @Manjari_Ramadas

If u are using excel application scope, instead of that try using workbook activitiy

Hope it helps yo

Nived N :robot:

Happy Automation :slight_smile:

#5

Pulled the do block out of excel app scope and the step went through. Thanks again @NIVED_NAMBIAR

#6

I didn’t understand what u said @Manjari_Ramadas

Did u tried with workbook activitiy?

#7

what do you mean workbook activity? I suppose you are referring to teh Read Range activity?

I was using Read Range under Excel Application Scope. I pulled it out of the scope and used directly. It works.

1 Like
#8

Can u share screenshot of that workflow

I think the error would be

You had used workbook read range activitiy under excel application scope

So excel application scope is using the excel file

So that is why the error is thrown

Refer for more information

Hope it helps

Nived N

#9

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