Cannot write to file while it is opened in MS Excel

Question

I am writing to the text file some data. I am using this code:

  using (FileStream fs = new FileStream(path, FileMode.Append, FileAccess.Write, FileShare.ReadWrite))
  {
      using (TextWriter tw = new StreamWriter(fs))
      {
      tw.WriteLine("sample_data");
      }
   }

When file is opened by notepad my app can write into it. When this file is opened by MS Excel I get following error: The process cannot access the file myfile.csv because it is being used by another process. What can cause this situation and how can I solve this problem?

I guess Excel can put an "exclusive" right to write in a file when it is using it. I'm not sure that you can bypass it. You can have some info [here](http://stackoverflow.com/questions/1977611/is-it-possible-to-bypass-a-file-lock-in-c-sharp-when-another-thread-process-is-u) — Flanfl, Nov 28 '11 at 19:25

score 8 · Accepted Answer · answered Nov 28 '11 at 19:31

Notepad opens the file, reads in the entire contents and then closes the file. You can even delete the file that is open in notepad.

Excel on the other hand keeps the file open as long as it is displayed. There are some special sharing tools that can be enabled in Excel for excel format files. In that case I assume that it is opened non-exlusively. Otherwise Excel opens the file exclusively and keeps it open.

It doesn't matter that you specify a share option when opening, if the file is already opened by someone else in exclusive mode.

score 1 · Answer 2 · edited May 23 '17 at 11:58

Excel will lock the file when it is open which prevents interaction with the file. One way I worked around this is that I wrote code to scan for excel processes on the local machine and would kill those processes before accessing a file that was open with excel. You could determine if a file is locked by looking at How to check for file lock? and then running the process killing code in the exception handler.

score -1 · Answer 3 · answered Nov 28 '11 at 19:54

-1

Open the csv file using OleDB and use INSERT and/or UPDATE statements.

answered Nov 28 '11 at 19:54

AMissico

21,470
7
78
106

Cannot write to file while it is opened in MS Excel

3 Answers3