The process excel crached when I use the plugin ExcelCompare.tcx

Nobody Can help me?

I work with Excel 2010. So I found the problem ExceCompare.tcx cannot crush the same excel result file. We want to save the result excel file with another name.

thanks a lot

Hi,



I have this issue too: EXCEL.EXE process crashed when I use Sys.OleObject("Excel.Application"); 





After I finished to deal with this object  I write  excel.Quit();



but still I can find this process in TaskManager.

And as result in log file I get this error.

Exception code: 0xC0000005.

Process identifier (PID): 300.

Dump file: EXCEL_ue_db3d188c.dmp.

Hi Iryna,



While I understand that this is not the easiest way, you may try the following:

a) ExcelCompare.tcx script extension is a Zip archive, so unpack it into some folder;

b) Change extension of the extracted file from .js to .sj;

c) If your test project uses JScript, just add extracted file to the project. If not, you will have to create a new JScript-based project, add extracted file to it and add a new script unit with the problematic test code converted to JScript;

d) Replace in your test code call to the script extension with the call to the relevant method from the extracted file;

e) Put a breakpoint in the extracted file near the crash point and start test execution. Debug extension's code in TestComplete. Hope you'll find the reason of the crash and let us and SmartBear's Support know.



P.S. BTW, exception code 5 is Access Denied one. Depending on where the crash error occurs, might it be that the file is either read-only, or located on the read-only resource, or some other similair problem exists?

Hi Alex, actually I don't use any ExcelCompare.tcx script extension, I just use standart object in TestComplete Sys.OleObject("Excel.Application"):

so I do the next:



  var app = Sys.OleObject("Excel.Application");  

    book = app.Workbooks.Open(fileName);

    sheet = book.Sheets(sheetName);

.....

    book.Save();

    book.Close();

    app.Quit();



but after "app.Quit();" EXCEL.EXE is still in process. And after I run a lot of tests in one time it is crashed.

Iryna,



What if you try

app = null;

after

app.Quit();

(with, maybe, some (dynamic) delay to wait for Excel to close) ?



Will this close Excel process?

Otherwise, you may try Sys.Process("Excel").Terminate(); to terminate Excel.