Exception in opening a file that is already open

by

I faced this problem some time back.

You are missing the FileShare parameter. Without specifying that, if you open a file, it will be locked exclusively by your application. But since it’s already been opened by Excel (or any other app), you will receive an exception.

You can try using this – I think this will be your best bet –

using (FileStream fs = File.Open(<file-path>, FileMode.Open, FileAccess.Read, FileShare.Read))

This code says: Hello Excel! If you may permit (read, not throw exception), I would like to read the file, though I will not try to own it and I know that you may modify it anytime.

If this throws error, then Excel has denied you even the read access. Too bad then!
All the best.

More Related Contents:

  1. How can I read, write, and modify the contents of a notepad (.txt) file, in Winform and WPF? [duplicate]
  2. Translucent circular Control with text
  3. Open existing file, append a single line
  4. How can I split a string with a string delimiter? [duplicate]
  5. catch exception that is thrown in different thread
  6. Is is possible to export functions from a C# DLL like in VS C++?
  7. Using .Net 4.5 Async Feature for Socket Programming
  8. Close a MessageBox after several seconds
  9. Tuples( or arrays ) as Dictionary keys in C#
  10. How to hide TabPage from TabControl [duplicate]
  11. using of INotifyPropertyChanged
  12. How to return text from Native (C++) code
  13. How to convert linq results to HashSet or HashedSet
  14. Why can’t I create an abstract constructor on an abstract C# class?
  15. Change the borderColor of the TextBox
  16. Usage of IoC Containers; specifically Windsor
  17. Unable to create a constant value – only primitive types
  18. Windows Forms window changes its size when I create a WPF window
  19. C# Is there a LINQ to HTML, or some other good .Net HTML manipulation API?
  20. Thread.Sleep() without freezing the UI
  21. Unity – Checking if the player is grounded not working
  22. Getting HTML body content in WinForms WebBrowser after body onload event executes
  23. Change GridView row color based on condition
  24. C#: HttpClient, File upload progress when uploading multiple file as MultipartFormDataContent
  25. How do I disable a system device? [duplicate]
  26. Deserialize JSON when a value can be an object or an empty array
  27. Quickest way in C# to find a file in a directory with over 20,000 files
  28. Can I use Roslyn for compile time code rewriting?
  29. The module was expected to contain an assembly manifest
  30. Exposing events of underlying control

Leave a Comment