I almost completed my first project. Main duties for this automation is to do some corss-check between the data contatined in 3-4 difrent excel files and then output the infomation about correctness/incorrectness of the data and the root that causes it. So, for now it consists of 7 modules which in almost each of them is the same logic(read ranges, for each row, look up data table, if condition, write a cell activity). It worked already perfectly but i came back to this project after 5 day’s and i have this error:
- Write Cell: The process cannot access the file ‘C:…\ZonesLocation.xlsx’ because it is being used by another process.
I tried to input some delays after writting the cell activity because i thoguht it could be affected by the diffrence between execution time and processing time but, when i put the delays after this activity i received another, the same kind of errors in my project in the same kind of place(in write a cell activity). I put another delays. The duration got longer and i have received another, diffrent error:
- The semaphore timeout period has expired delay.
I tried to shortage delays with this error but i received them in other(same kind) places. And in some cases it was the obstacle that i couldn’t effort.
So here’s my question’s:
What is the purpouse of the first part of my problem(,Cannot access file because using by other process") and what solution will fix this? (honestly i want to avoid the delays and longer time duration)
What is the purpouse and solution for second part of my problem(,the semaphore timeout period has expired delay")?
I want jut add, that i have had exactly the same error’s during developing it but i changed a bit logic and move two variables from “Global” scope to specific module and it fixed. But why it still happen? I didn’t changed anything.
I’m resigned already because i spent an hours on fixing this with no effect so i hope i will find any help here.