Click here to Skip to main content
12,760,177 members (35,214 online)
   

C#

 
GeneralRe: XML Mapping to CSV Pin
RickSharp4-Jan-13 7:05
memberRickSharp4-Jan-13 7:05 
GeneralRe: XML Mapping to CSV Pin
PIEBALDconsult4-Jan-13 11:46
memberPIEBALDconsult4-Jan-13 11:46 
GeneralRe: XML Mapping to CSV Pin
RickSharp4-Jan-13 14:22
memberRickSharp4-Jan-13 14:22 
GeneralRe: XML Mapping to CSV Pin
jschell4-Jan-13 15:12
memberjschell4-Jan-13 15:12 
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 
GeneralRe: KeyValuePair from reference dll Pin
Super Lloyd3-Jan-13 23:48
memberSuper Lloyd3-Jan-13 23:48 
GeneralRe: KeyValuePair from reference dll Pin
Isaksson4-Jan-13 1:41
memberIsaksson4-Jan-13 1:41 
Questionhow to connect and disconnect to internet by Exist connection Pin
apadana_19892-Jan-13 18:44
memberapadana_19892-Jan-13 18:44 
QuestionRe: how to connect and disconnect to internet by Exist connection Pin
Richard MacCutchan2-Jan-13 23:15
mvpRichard MacCutchan2-Jan-13 23:15 
AnswerRe: how to connect and disconnect to internet by Exist connection Pin
jschell3-Jan-13 9:11
memberjschell3-Jan-13 9:11 
QuestionHow to create a colletion of properties in a C# class Pin
bnath0012-Jan-13 13:59
memberbnath0012-Jan-13 13:59 
AnswerRe: How to create a colletion of properties in a C# class Pin
PIEBALDconsult2-Jan-13 14:34
memberPIEBALDconsult2-Jan-13 14:34 
AnswerRe: How to create a colletion of properties in a C# class Pin
Abhinav S2-Jan-13 16:42
mvpAbhinav S2-Jan-13 16:42 
AnswerRe: How to create a colletion of properties in a C# class Pin
OriginalGriff2-Jan-13 22:16
mvpOriginalGriff2-Jan-13 22:16 
GeneralRe: How to create a colletion of properties in a C# class Pin
bnath0013-Jan-13 6:59
memberbnath0013-Jan-13 6:59 
GeneralRe: How to create a colletion of properties in a C# class Pin
OriginalGriff3-Jan-13 9:24
mvpOriginalGriff3-Jan-13 9: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.


Advertise | Privacy | Mobile
Web01 | 2.8.170217.1 | Last Updated 24 Feb 2017
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid