Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
S

SaneLucky

@SaneLucky
About
Posts
1
Topics
1
Shares
0
Groups
0
Followers
0
Following
0

Posts

Recent Best Controversial

  • Reading Excel from different processes in different computer
    S SaneLucky

    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?

    C# help csharp question
  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups