how to check if a file/exe is already open

Question

0.00/5 (No votes)

See more:

Hi Coders,
How can I check if a file say "C:\abc.xls" file is already open or not, if yes then how to close it.

Problem: The problem I am facing is: My code crashes When I try to write a file which is already open, how can I solve it? Answer to my question above will be a part of solution to my problem

Thanks in advance
Deepak

Posted 18-Aug-10 22:42pm

deepakkumargautam

Updated 18-Aug-10 23:21pm

Emilio Garavaglia

v2

Add a Solution

Comments

Eugen Podsypalnikov 19-Aug-10 4:53am

Could you post the code part, that "crashes", please ? :)

deepakkumargautam 19-Aug-10 5:20am

workbook = excel->Workbooks->Add(static_cast<long>(Excel::xlWorksheet)); // Create the workbook
worksheet = excel->ActiveSheet; // Get the active sheet

//some code//

worksheet->SaveAs(_strPath); // here comes the error when I try to save an
// excel file alraedy open

Emilio Garavaglia 19-Aug-10 5:21am

Retagged as C++/CLI

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

shivaprasadk · Accepted Answer · 2010-08-18T23:06:00

Hi,

you can check the file mode using the following code:

try
                {
//Verify whether the file opens in write mode
                    using (Stream stream = File.Open(e.FullPath, FileMode.Open, FileAccess.ReadWrite, FileShare.ReadWrite))
                    {
                        if (stream != null)
                        {
                       // File is available for write.
                            break;
                        }
                    }
                }
                catch (FileNotFoundException ex)
                {
                //The file is not found.
}
                catch (IOException ex)
                {
                    //File is undergoing some operation. May be write or copy, etc
                }
                catch (UnauthorizedAccessException ex)
                {
                    //the User is not authorised to use the file
                }

#realJSOP · Accepted Answer · 2010-08-18T23:15:00

Solution 2

shiva's answer is almost there. When you try to open the file, use FileShare.None. If the file is already open, attempting to open the file with FileShare.None with throw an exception that you can react to.

Posted 18-Aug-10 23:15pm

#realJSOP

shivaprasadk · Accepted Answer · 2010-08-18T23:37:00

Solution 3

Hi,

Just add

using System.IO;

Posted 18-Aug-10 23:37pm

shivaprasadk

Comments

deepakkumargautam 19-Aug-10 6:00am

Done that Shiva but stil getting some errorrs "steam underclared undentifier, same for FILE " ?

shivaprasadk 19-Aug-10 6:16am

Deepak, it is better, if you post the code which is throwing error.

deepakkumargautam 19-Aug-10 6:34am

void g_fnWriteExcelFile(CSite *_objSite,char *_strPath)
{
char Range[7],bufCtr[10];
CString _strOutputName;
CoInitialize(NULL);
Excel::_WorkbookPtr workbook ;
Excel::_ApplicationPtr excel;
Excel::_WorksheetPtr worksheet ;
try
{
Excel::_ApplicationPtr excel ;
// Initialize Excel and make sure it's initialized
HRESULT hr = excel.CreateInstance(L"Excel.Application");
if(FAILED(hr))
{
return ;
}

workbook = excel->Workbooks->Add(static_cast<long>(Excel::xlWorksheet)); // Create the workbook
worksheet = excel->ActiveSheet; // Get the active sheet

//tempstrPath = (char*)malloc(sizeof(_strPath));
_strOutputName = _objSite->m_strPrefix + "_" + "MappingResult";
worksheet->Name=(_bstr_t)_strOutputName;

strcat(_strPath,"\");

_strOutputName = _strOutputName + ".xlsx"; // excel 2007
strcat(_strPath,_strOutputName) ;

_variant_t var;

CDevice *_objDevice = _objSite->m_objDevice;
CDevicePoint *_objDevicePoint = NULL;

///////////////////////////////Header Start/////////////////////////////////////////
int nCounter = 1;

while(_objDevice!=NULL)
{
_objDevicePoint = _objDevice->m_objDevicePoint;
while(_objDevicePoint!=NULL)
{
if(nCounter == 2)
{
CString tempColor = "15" ;

strcpy(Range,"A");
itoa(nCounter,bufCtr,10);
strcat(Range,bufCtr);
worksheet->Range[Range]->Value2 = "Tag Name";
_objDevicePoint = _objDevicePoint->next ;
}
nCounter++;

}
_objDevice = _objDevice->next ;
}
worksheet->SaveAs(_strPath); // saving workshee
workbook->Close(); // Close the workbook
excel->Quit(); // Quit excel
}
catch(_com_error &ce)
{
// Handle the error
AfxMessageBox(ce.ErrorMessage()) ;

}
CoUninitialize();
}