Close the File that Opend in C#

Question

I have to engage an Excel file into an operation.The operation will be sucess if the Excel file in close mode.If it is opend then the error will populate Excel file used in another process. What i want is before runs an application Close the excel file even if it is opened.please help me to solve this.

Manas Mohapatra · Answer

Before you perform any operation on File please check a file is being by other program. Follow below links: http://dotnet-assembly.blogspot.in/2012/10/c-check-file-is-being-used-by-another.html https://stackoverflow.com/questions/424830/detecting-whether-a-file-is-locked-by-another-process-or-indeed-the-same-proces public bool FileIsLocked( string strFullFileName) { bool blnReturn = false ; System.IO.FileStream fs; try { fs = System.IO.File.Open(strFullFileName IO.FileMode.OpenOrCreate IO.FileAccess.Read IO.FileShare.None); fs.Close(); } catch (System.IO.IOException ex) { blnReturn = true ; } return blnReturn; }

Saravanan Ponnusamy · Answer

This link may useful for you http://www.c-sharpcorner.com/article/c-sharp-to-overcome-the-process-cannot-access-the-file-xyz-because-it-is-being-used/

Gokhul Varman · Answer

please refer the link more details:https://stackoverflow.com/questions/3526802/forcing-closed-an-open-file-by-c-sharp