Excel installation not detected in Manage Data Sources
Posted: Mon Dec 04, 2017 11:43 pm
I'm modifying the location of existing data sources in a Ranorex Solution that was developed by the team. I have a new installation of Ranorex on my development machine for the first time and have pulled the solution in from source control. The data source files are in Excel and were not properly placed. I'm fixing that and the reference to them... or trying to with no success thus far.
I'm changing the file path to the relative path in the solution by picking the file in the file selector dialog. After Ranorex populates the file path text box I'm editing to make the path relative in the files current location. Everything is good at this point. When I click Apply I get the error "Excel is not installed. ExcelDataConnector requires Excel to be installed".
Checking in my machines registry I have it at C:\Program Files\Microsoft Office\root\Office16\ in Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Excel\InstallRoot
Any help will be greatly appreciated!
I'm changing the file path to the relative path in the solution by picking the file in the file selector dialog. After Ranorex populates the file path text box I'm editing to make the path relative in the files current location. Everything is good at this point. When I click Apply I get the error "Excel is not installed. ExcelDataConnector requires Excel to be installed".
Checking in my machines registry I have it at C:\Program Files\Microsoft Office\root\Office16\ in Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\16.0\Excel\InstallRoot
Any help will be greatly appreciated!