Is Excel 2016 compatible with TestComplete 12?

Hi,

The most probable reason of your problem is that you are trying to read Excel data using TestComplete (TC) 64-bit.

The shortcut that is placed on your desktop after TestComplete install points to the 64-bit flavor of TC that is located in the <TestComplete>\x64\bin\ folder.

At the same time, TC installer also installs 32-bit flavor of TC into the usual <TestComplete>\bin\ folder but does not create any shortcut to it.

When you are accessing (Excel) data from TC via ADO (and this is how it is implemented in TC), the bitness of the master application and ADO providers (as well as ODBC drivers if your ADO connection string specifies them) must be the same.

The problem here is that in 99% of cases, required 32-bit ADO providers are already present on the computer, while 64-bit versions are not. To make things even worse, 32-bit Excel providers cannot be installed side-by-side with 64-bit ones.

With more details this is described here: https://support.smartbear.com/testcomplete/docs/general-info/system-requirements.html#additional-requirements

So, what I would recommend is to try 32-bit flavor of TC and check if it works for you. (The functionality of 32- and 64-bit flavors of TC from the end-user's point of view is absolutely the same.)

Hi,

I also use Office 365 which is 2016.

I have below function which will grab my excel data wherever you run.

function fn_ExcelUsingADODB()
{
      var ctExcelProvider64 = "Microsoft.ACE.OLEDB.12.0",ctExcelProvider32 = "Microsoft.Jet.OLEDB.4.0";
      var excelFileName = "<test data path>";
      var excelConnection = new Sys.OleObject("ADODB.Connection");
      
      var str_Connection = "Provider=" + (is64BitClient() ? ctExcelProvider64 : ctExcelProvider32) + ";Data Source = " + excelFileName + ";Persist Security Info=False;Extended Properties=Excel 8.0;"
      
      excelConnection.Open(str_Connection);
      
      var excel_recordSet = new Sys.OleObject("ADODB.Recordset");
      
      var excelQuery = "select * from [<sheetName>$]" ;
      
      excel_recordSet.Open(excelQuery, excelConnection);
      
      if(!excel_recordSet.bof)
      {
            excel_recordSet.MoveFirst()
            while(!excel_recordSet.eof)
            {
                  for(var i=0; i!= excel_recordSet.fields.count; ++i)
                  {
                        Log.Message(excel_recordSet.fields.Item(i).name);
                  }
                  
            }
      }
      excel_recordSet.Close();
      excelConnection.Close();
}
function is64BitClient()
{
      var tcprocess = Sys.WaitProcess("Test*te", 0);
      
      if(tcprocess.Exists)
      {
            if(tcprocess.ProcessType == "x64")
            {
                  return true;
            }
            else if(tcprocess.ProcessType == "x86")
            {
                  return false;
            }
            else
            {
                  throw "Not able to grab the process type";
            }
      }
      throw "Not able to find the TestComplete/TestExecute process";   
}

You have to install this x64 version access control if you want to use TestComplete as x64 bit.

Thanks for your reply. I am just doing the tutorial for data driven tests and have not yet got to the code window yet.

From what I gather, without writing code - which I'm not opposed to doing, just haven't gotten there yet as I'm just beginning to use the tool - there isn't a way to use 64 bit Excel with TestComplete. Seems odd.

Thanks again for your reply but I'm still looking for a solution.