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...
shankar_r's avatar
shankar_r
Community Hero
8 years ago

I'm not sure you can compare two excel files or excel sheets using Dictionary object. 

 

And also there is no way to get ExcelObj as undefined from your code since there is no ExcelObj is mentioned in your code.

 

Can you post log which you got for this.

  • nsag_1512's avatar
    nsag_1512
    Occasional Contributor
    8 years ago
    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