Click here to Skip to main content
12,067,928 members (43,579 online)
   

C#

 
AnswerRe: XML Mapping to CSV Pin
jschell4-Jan-13 15:11
memberjschell4-Jan-13 15:11 
Questionhow to setup that form in the tabpage when tabpage resized Pin
linuxaidtest3-Jan-13 4:47
memberlinuxaidtest3-Jan-13 4:47 
AnswerRe: how to setup that form in the tabpage when tabpage resized Pin
BillWoodruff3-Jan-13 17:42
memberBillWoodruff3-Jan-13 17:42 
QuestionReading Excel from different processes in different computer Pin
SaneLucky3-Jan-13 3:58
memberSaneLucky3-Jan-13 3:58 
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?
AnswerRe: Reading Excel from different processes in different computer Pin
Super Lloyd3-Jan-13 18:55
memberSuper Lloyd3-Jan-13 18:55 
AnswerRe: Reading Excel from different processes in different computer Pin
April Fans3-Jan-13 20:33
memberApril Fans3-Jan-13 20:33 
AnswerRe: Reading Excel from different processes in different computer Pin
micke.andersson28-Jan-13 5:45
membermicke.andersson28-Jan-13 5:45 
QuestionKeyValuePair from reference dll Pin
Isaksson3-Jan-13 2:52
memberIsaksson3-Jan-13 2:52 
AnswerRe: KeyValuePair from reference dll Pin
Super Lloyd3-Jan-13 18:51
memberSuper Lloyd3-Jan-13 18:51 
GeneralRe: KeyValuePair from reference dll Pin
Isaksson3-Jan-13 22:14
memberIsaksson3-Jan-13 22:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web02 | 2.8.160208.1 | Last Updated 8 Feb 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid