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
- nsag_15128 years agoOccasional Contributor
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
- shankar_r8 years agoCommunity Hero
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
- nsag_15128 years agoOccasional Contributor
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.
Related Content
- 2 years ago
- 5 years ago
- 2 years ago
- 7 years ago
Recent Discussions
- 3 hours ago
- 4 days ago