Close the File that Opend in C#

Dinesh Santhalingam

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

kenneth quirici5y ago
Yes, I have to close a file I opened before I can save it.

Duh.

Thanks.

Ken
+1
Saravanan Ponnusamy9y ago
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/
+1
Gokhul Varman9y ago
please refer the link more details:https://stackoverflow.com/questions/3526802/forcing-closed-an-open-file-by-c-sharp
+1
Manas Mohapatra9y ago
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;
}
+3