windows11 Failed to load Excel file

Ask general questions here.
User avatar
doke
Posts: 112
Joined: Fri Mar 29, 2019 2:33 pm

windows11 Failed to load Excel file

Post by doke » Mon Nov 29, 2021 6:07 pm

Hi,

recently we added new windows11 ranorex execution machine.

when running our regression set we get this error:
Failed to load Excel file (c:\jenkinsnode\workspace\ranorex_master\Testdata\Mytestdata.xlsx). Excel or the 'Microsoft Access Database Engine' (version 2010 or higher) must be installed.

on our windows10 execution environments there is no excel/access installed and it runs flawless.

anyone else encoutered and solved this issue?

Regards
Don.

Show/Hide Stacktrace
bij Ranorex.Core.Data.ExcelDataConnector.ValidateLoadingPreference(String resolvedFileName)bij Ranorex.Core.Data.ExcelDataConnector.LoadDataInternal(Boolean loadRowData, ColumnCollection& columns, RowCollection& rows, Int32& rowCount)bij Ranorex.Core.Data.ExcelDataConnector.LoadDataImpl(ColumnCollection& columns, RowCollection& rows)bij Ranorex.Core.Data.DataConnector.LoadData(ColumnCollection& columns, RowCollection& rows)bij Ranorex.Core.Data.DataCache.LoadInternal()bij Ranorex.Core.Testing.TestCaseNode.GetRangedDataRowCount()bij Ranorex.Core.Monitoring.TestSuiteMonitor.TestCaseNodesCounter.CollectAncestorsIterations(TestCaseNode testCaseNode)bij Ranorex.Core.Monitoring.TestSuiteMonitor.TestCaseNodesCounter.<>c__DisplayClass0_0.<CalculateTestCasesExecCount>b__0(TestCaseNode tcn)bij Ranorex.Common.Extensions.EnumerableExtensions.ForAll[T](IEnumerable`1 e, Action`1 action)bij Ranorex.Core.Monitoring.TestSuiteMonitor.TestCaseNodesCounter.CalculateTestCasesExecCount(TestSuite testSuite)bij Ranorex.Core.Monitoring.TestSuiteMonitor.TestSuiteStarted(TestSuite testSuite)bij Ranorex.Core.Testing.TestSuite.Run(String runConfigName, String runLabel, Dictionary`2 parameters)bij Ranorex.Core.Testing.TestSuiteRunner.TryRunTestSuite(RunParams rp, TestSuite testSuite)bij Ranorex.Core.Testing.TestSuiteRunner.<>c__DisplayClass13_1.<RunInternal>b__6()bij Ranorex.Common.Types.OptCombinators.UnwrapOrElse[T](Opt`1 self, Func`1 generator)bij Ranorex.Core.Testing.TestSuiteRunner.RunInternal(Type containerType, String[] testSuiteXmls, RunParams[] rps)

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 7470
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: windows11 Failed to load Excel file

Post by odklizec » Mon Nov 29, 2021 6:19 pm

Hi,

There must definitely be installed either Excel or the 'Microsoft Access Database Engine' (version 2010 or higher). So my guess is that on the other (working) machine, there is installed MS Access DB engine? Otherwise, excel data connector would not work there as well.
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

User avatar
doke
Posts: 112
Joined: Fri Mar 29, 2019 2:33 pm

Re: windows11 Failed to load Excel file

Post by doke » Tue Nov 30, 2021 9:20 am

Hi Pavel,
Thanks for the hint.
Looks like our win10 images had this pre-installed.

installing accessdatabaseengine_X64 solved this issue

Regards,
Don