Compare excel files(ExcelObj is undefined )
I'm trying to compare two excel files using below code, I'm getting error 'ExcelObj' is undefined'. Please help... Thanks :) function Excel() { var oExcel = Sys.OleObject("Excel.Appli...
Forum Discussion
function Main()
{
var oExcel = Sys.OleObject("Excel.Application");
var aSheets = Sys.OleObject("Scripting.Dictionary");
//You can specify the sheet to be compared
//var vSheet = "Sheet1";
//aSheets.Add(vSheet, vSheet);
var fileName = "C:\\Users\\ghaniabd\\Desktop\\excel";
var aInfo1 = ExcelObj.CreateInfo(oExcel, "1.xlsx", "Aging Summary (01 1 2017 - 03 1");
var fileName = "C:\\Users\\ghaniabd\\Desktop\\excel";
var aInfo2 = ExcelObj.CreateInfo(oExcel, "2.xlsx", "Aging Summary (01 1 2017 - 03 1");
var oResult = ExcelObj.Compare(aInfo1, aInfo2);
if (oResult.length > 0)
{
Log.Warning(oResult);
}
else
{
Log.Message("The files are the same.");
}
oExcel.Quit();
}Sorry this is latest the code with the ExcelObj..
Again ExcelObj is not initialized anywhere in your code hence you are getting ExcelObj is undefined error.
You have define a object like var ExcelObj = "Object value"
Also, I don't think using your code excel files or sheets can be compared
i get the above code from the test complete coampre excel file article..
Here is the articel path https://support.smartbear.com/viewarticle/9046/#_ga=1.140248566.49838654.1488187804
Gotcha...
1. Download the script extension from the link https://support.smartbear.com/images/support/kb/data/2010/6/1/ExcelSheetCompare.tcx
2. Place it into *\SmartBear\TestComplete 12\Bin\Extensions\ScriptExtensions
3. In Test Complete, File > Install Script Extension
4. Click on Reload
5. After reload you will see the Script Extension
Then you can use your existing code do a compare. let me know if this works
i able to see the extension after click the reload btn. But i get new error message when running the script. Below is the screenshot of the error.
