Click here to Skip to main content
15,888,113 members
Home / Discussions / C#
   

C#

 
GeneralRe: XML Mapping to CSV Pin
RickSharp4-Jan-13 6:05
RickSharp4-Jan-13 6:05 
GeneralRe: XML Mapping to CSV Pin
PIEBALDconsult4-Jan-13 10:46
mvePIEBALDconsult4-Jan-13 10:46 
GeneralRe: XML Mapping to CSV Pin
RickSharp4-Jan-13 13:22
RickSharp4-Jan-13 13:22 
GeneralRe: XML Mapping to CSV Pin
jschell4-Jan-13 14:12
jschell4-Jan-13 14:12 
AnswerRe: XML Mapping to CSV Pin
jschell4-Jan-13 14:11
jschell4-Jan-13 14:11 
Questionhow to setup that form in the tabpage when tabpage resized Pin
linuxaidtest3-Jan-13 3:47
linuxaidtest3-Jan-13 3:47 
AnswerRe: how to setup that form in the tabpage when tabpage resized Pin
BillWoodruff3-Jan-13 16:42
professionalBillWoodruff3-Jan-13 16:42 
QuestionReading Excel from different processes in different computer Pin
SaneLucky3-Jan-13 2:58
SaneLucky3-Jan-13 2: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 17:55
Super Lloyd3-Jan-13 17:55 
AnswerRe: Reading Excel from different processes in different computer Pin
April Fans3-Jan-13 19:33
April Fans3-Jan-13 19:33 
AnswerRe: Reading Excel from different processes in different computer Pin
micke.andersson28-Jan-13 4:45
micke.andersson28-Jan-13 4:45 
QuestionKeyValuePair from reference dll Pin
Isaksson3-Jan-13 1:52
Isaksson3-Jan-13 1:52 
AnswerRe: KeyValuePair from reference dll Pin
Super Lloyd3-Jan-13 17:51
Super Lloyd3-Jan-13 17:51 
GeneralRe: KeyValuePair from reference dll Pin
Isaksson3-Jan-13 21:14
Isaksson3-Jan-13 21:14 
GeneralRe: KeyValuePair from reference dll Pin
Super Lloyd3-Jan-13 22:48
Super Lloyd3-Jan-13 22:48 
GeneralRe: KeyValuePair from reference dll Pin
Isaksson4-Jan-13 0:41
Isaksson4-Jan-13 0:41 
Questionhow to connect and disconnect to internet by Exist connection Pin
apadana_19892-Jan-13 17:44
apadana_19892-Jan-13 17:44 
QuestionRe: how to connect and disconnect to internet by Exist connection Pin
Richard MacCutchan2-Jan-13 22:15
mveRichard MacCutchan2-Jan-13 22:15 
AnswerRe: how to connect and disconnect to internet by Exist connection Pin
jschell3-Jan-13 8:11
jschell3-Jan-13 8:11 
QuestionHow to create a colletion of properties in a C# class Pin
bnath0012-Jan-13 12:59
bnath0012-Jan-13 12:59 
AnswerRe: How to create a colletion of properties in a C# class Pin
PIEBALDconsult2-Jan-13 13:34
mvePIEBALDconsult2-Jan-13 13:34 
AnswerRe: How to create a colletion of properties in a C# class Pin
Abhinav S2-Jan-13 15:42
Abhinav S2-Jan-13 15:42 
AnswerRe: How to create a colletion of properties in a C# class Pin
OriginalGriff2-Jan-13 21:16
mveOriginalGriff2-Jan-13 21:16 
GeneralRe: How to create a colletion of properties in a C# class Pin
bnath0013-Jan-13 5:59
bnath0013-Jan-13 5:59 
GeneralRe: How to create a colletion of properties in a C# class Pin
OriginalGriff3-Jan-13 8:24
mveOriginalGriff3-Jan-13 8:24 

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.