Hi,
I am automating a web application in which the data gets fetched from excel sheet to web application. But the excel sheet needs to be used by two different systems. So, is there a way by which two systems share that excel sheet among themselves and when one of them updates the data it gets synched in both the systems?
Hi,
When one process access an excel file then it gets locked by that process. Just as two person cannot work on same excel simultaneously manually similarly two process cannot update same excel file concurrently
Regards,
Amit Anand
Hi,
By two process, did you mean two different processes or one process in two different systems but with same user id?
Hi,
At same time only one user can access the excel sheet. It is not possible to share
Regards,
Amit