Hello, I've an application which reads and writes to a shared excel using C#. The application runs on different computers and whenever anybody writes to the excel a pop-up appears on all the computers in which the application is running and displays the recent message written to excel file. I am using FileSystemWatcher and an event is raised whenever something is written to the file. If this event occurs I am reading the excel file from each of the process and displaying the latest message. Now, when I am reading the excel file from different computers(processes) at the same time. All the processes does not get the latest message. I am opening the excel in readOnly and releasing the excel object successfully. Also, I have found that when many processes are trying to read from the same excel at the same time. The excel tends to crash. I have added a thread.sleep(3000) so that there is a delay in reading the excel file. This did help but still the excel throws error messages. Is there anyway that I can read excel file one after the other from each process?
S
SaneLucky
@SaneLucky