Skip to main content

Hello,

I am facing an error which mentions my excel is being used by another process. But I dont have any instances of the excel open. In the process, I am saving values of particular columns from Excel1 and saving them in Excel2 (I am looping the table of data from Excel1). Excel1 has more than 300 total values. When I am running the Bot, it fails after executing few records & displays below message. But if I add a 1 Second delay (as shown in second image) just before the saving action (Line 22 without the delay action, mentioned in the error message), everything goes through. Unfortunately I cannot put a 1 second time delay since I need to process around 500-1000 rows quickly when this goes live as it is part of a bigger process. What might causing the issue here? Any help is appreciated, thank you!

 

Hi ​@aaditya.newaskar ,

 

Try using the EXCEL kill task before actually opening your Excel file to make sure that no other Excel sessions won't be running in the backend.

 

Additionally, since you are dealing with huge data set, I would recommend to use either Database or DataTable action instead of Excel advanced for faster execution.


@aaditya.newaskar Your problem is likely related to OneDrive. Try working with files on your hard drive directly instead. I've seen this issue in the past. 


Hi ​@aaditya.newaskar ,

 

Try using the EXCEL kill task before actually opening your Excel file to make sure that no other Excel sessions won't be running in the backend.

 

Additionally, since you are dealing with huge data set, I would recommend to use either Database or DataTable action instead of Excel advanced for faster execution.

@Padmakumar thanks for replying, actual issue was with Onedrive. When i transferred files to local it worked. Am also looking to convert to db.


@aaditya.newaskar Your problem is likely related to OneDrive. Try working with files on your hard drive directly instead. I've seen this issue in the past. 

@Aaron.Gleason yes that was the problem, thanks a lot!