Click here to Skip to main content
       

C#

 
GeneralRe: XML Mapping to CSV PinmemberRickSharp4-Jan-13 6:05 
GeneralRe: XML Mapping to CSV PinmemberPIEBALDconsult4-Jan-13 10:46 
GeneralRe: XML Mapping to CSV PinmemberRickSharp4-Jan-13 13:22 
GeneralRe: XML Mapping to CSV Pinmemberjschell4-Jan-13 14:12 
AnswerRe: XML Mapping to CSV Pinmemberjschell4-Jan-13 14:11 
Questionhow to setup that form in the tabpage when tabpage resized Pinmemberlinuxaidtest3-Jan-13 3:47 
AnswerRe: how to setup that form in the tabpage when tabpage resized PinmemberBillWoodruff3-Jan-13 16:42 
QuestionReading Excel from different processes in different computer PinmemberSaneLucky3-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 PinmemberSuper Lloyd3-Jan-13 17:55 
AnswerRe: Reading Excel from different processes in different computer PinmemberApril Fans3-Jan-13 19:33 
AnswerRe: Reading Excel from different processes in different computer Pinmembermicke.andersson28-Jan-13 4:45 
QuestionKeyValuePair from reference dll PinmemberIsaksson3-Jan-13 1:52 
AnswerRe: KeyValuePair from reference dll PinmemberSuper Lloyd3-Jan-13 17:51 
GeneralRe: KeyValuePair from reference dll PinmemberIsaksson3-Jan-13 21:14 
GeneralRe: KeyValuePair from reference dll PinmemberSuper Lloyd3-Jan-13 22:48 
GeneralRe: KeyValuePair from reference dll PinmemberIsaksson4-Jan-13 0:41 
Questionhow to connect and disconnect to internet by Exist connection Pinmemberapadana_19892-Jan-13 17:44 
QuestionRe: how to connect and disconnect to internet by Exist connection PinmvpRichard MacCutchan2-Jan-13 22:15 
AnswerRe: how to connect and disconnect to internet by Exist connection Pinmemberjschell3-Jan-13 8:11 
QuestionHow to create a colletion of properties in a C# class Pinmemberbnath0012-Jan-13 12:59 
AnswerRe: How to create a colletion of properties in a C# class PinmemberPIEBALDconsult2-Jan-13 13:34 
AnswerRe: How to create a colletion of properties in a C# class PinmvpAbhinav S2-Jan-13 15:42 
AnswerRe: How to create a colletion of properties in a C# class PinmvpOriginalGriff2-Jan-13 21:16 
GeneralRe: How to create a colletion of properties in a C# class Pinmemberbnath0013-Jan-13 5:59 
GeneralRe: How to create a colletion of properties in a C# class PinmvpOriginalGriff3-Jan-13 8:24 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    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.140415.2 | Last Updated 20 Apr 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Use
Layout: fixed | fluid