Unable to access the excel file
Hello, I am using MS Excel as my test case file. I load in the run time and execute all the test cases file and then exit the function. But if the sometimes due to script error if the test e...
Forum Discussion
I'm also working with Excel via COM but never faced locking issue. I've used following lines of code before working with Excel File, may be it will help you.
excel = Sys.WaitProcess('EXCEL');
if(excel.Exists)
excel.Terminate();
try
{
MsExcel = Sys.OleObject("Excel.Application");
}
catch(exception)
{
Log.Warning("Unable to initialize MS Excel.", "", pmHigher);
return;
}
// rest of the code opening workbook and visible excel here.