at the end of one of my tests I have to compare 2 excel files.
I tried FileCheckpoints, but they are not useful for excel. So I found the ExcelCompare script extension: http://support.smartbear.com/viewarticle/42199/
But this extension does not work at all for me.
It uses about 300MB RAM and crashes each time without any result.
I call it like this:
The size of these excel files is about 300 kb.
The problem occurs with Excel 2013 and Excel 2010.
What do I do wrong?
Is there any other way to easily compare 2 Excel files without coding the comparison from scratch?
Line 96 (resBook.SaveAs resultFile) of the script throws an exception when attempting to save as .XLSM.
the comparison works, but there are two problems:
1) TestComplete always logs an error: The EXCEL.EXE process crashed.
2) performance: with my 300kb files the comparison took 2.5 minutes.
like this (slow, instable) it's not really an option.
I saved as xlsx the last few tries, but it did not work as well.
we are now scripting our own ExcelComparison
(extracting sheets and comparing sheets)
Performance is waaaaaaaaay better than the Script Extension.
Yea I didn't dig too deep into it, but it certainly didn't look like the most efficient process ;).
How about this extension: http://support.smartbear.com/viewarticle/9046/ ?
I did not compare it with the http://support.smartbear.com/viewarticle/42199/ (Quickly Compare Excel Files) one, so the performance might or might not be better...
Hey guys is it possible to provide source code for this script extension?
The source code of script extensions is included in the extension itself. Rename the extension from .tcx to .zip and unzip - the source code is in the .js and .vbs files.