Excel Onchanged Event keeps getting called

Question

0.00/5 (No votes)

See more:

I am writing to excel file. I am raising a event whenever the excel file changes.

C#

private void FileChanged()
       {

           watcher.Path = DirectoryPath;
           watcher.Filter = "*.xlsx";
           watcher.NotifyFilter = NotifyFilters.FileName | NotifyFilters.LastWrite;

           watcher.Changed += new FileSystemEventHandler(OnChanged);
           watcher.EnableRaisingEvents = true;

       }

I am expecting the OnChanged method would be called when I Open the file for writing but I am seeing the OnChanged method keeps getting called several times.

In the OnChanged method I am not doing anything if it is the same process. Only if it is a different process then I am reading from excel file.

Your help is appreciated.

Posted 4-Jan-13 10:14am

SaneLucky

Add a Solution

2 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Andrew Rissing · Answer 1 · 2013-01-04T11:07:00

MSDN[^] wrote:
Common file system operations might raise more than one event. For example, when a file is moved from one directory to another, several OnChanged and some OnCreated and OnDeleted events might be raised. Moving a file is a complex operation that consists of multiple simple operations, therefore raising multiple events. Likewise, some applications (for example, antivirus software) might cause additional file system events that are detected by FileSystemWatcher.

What you will likely need to do is buffer the events coming out of the FileSystemWatcher.

Something like the following might work[^].

You might want to do some digging around for other implementations, as I'm not familiar with that but it seems like that could prove useful as a starting point.

Enjoy.

Garth J Lancaster · Answer 2 · 2013-01-04T11:29:00

Solution 2

JSOP also has two articles which (may) help you understand some of the things going on - see

FileSystemWatcher - Pure Chaos (Part 1 of 2)[^]

and part 2, particularly for the 'quirks'

FileSystemWatcher - Pure Chaos (Part 2 of 2)[^]

'G'

Posted 4-Jan-13 11:29am

Garth J Lancaster

Excel Onchanged Event keeps getting called

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Excel Onchanged Event keeps getting called

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us