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; }

kenneth quirici · Answer

Yes, I have to close a file I opened before I can save it. Duh. Thanks. Ken

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

Close the File that Opend in C#

Answers (4)