0

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

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????

19th Jan 2019, 7:53 AM
Velivela Sai Chinna Madhu Babu
Velivela Sai Chinna Madhu Babu - avatar
2 Réponses
+ 3
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).
19th Jan 2019, 8:24 AM
Louis
Louis - avatar
+ 1
Thank you Louis
19th Jan 2019, 9:46 AM
Velivela Sai Chinna Madhu Babu
Velivela Sai Chinna Madhu Babu - avatar