Forum Discussion

nsag_1512's avatar
nsag_1512
Occasional Contributor
8 years ago

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...
nsag_1512's avatar
nsag_1512
Occasional Contributor
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.. 

shankar_r's avatar
shankar_r
Community Hero
8 years ago

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