Can anyone suggest me how to work on SHARED excel using python win32com.client

Question

when two persons are writing some data into excel using Python win32 in parallel .
data is not saving ....
can some one help me how can achieve this????

Answer 1

I do not think it is possible to have succesfull simultanious write acces from two seperate python instances to one excel file

What may work ( Not 100% sure) is to have 3 excel files.
A,B and C.
The one python instance writes to A, the other to B, and all that C does is pull in the required data from A and B. You may have to refresh manually in C. (F9).

Answer 2

Thank you Louis