Hello,
i am trying to open an excel file read values from a cell, execute my test and save the output in a cell and close the excel file. i am trying to use the example codes from this forum. i get the following error.
Task failed because "AxImp.exe" was not found, or the correct Microsoft Windows SDK is not installed. The task is looking for "AxImp.exe" in the "bin" subdirectory beneath the location specified in the InstallationFolder value of the registry key HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SDKs\Windows\v8.0A\WinSDK-NetFx40Tools-x86. You may be able to solve the problem by doing one of the following: 1) Install the Microsoft Windows SDK. 2) Install Visual Studio 2010. 3) Manually set the above registry key to the correct location. 4) Pass the correct location into the "ToolPath" parameter of the task. (MSB3091)
i am using correct references
using Excel=Microsoft.Office.Interop.Excel;
using System.Runtime.InteropServices;
i have also added the excel object in the COM reference library.
i have reinstalled Win SDK.
please help.
Thank you
Excel File read/write
Re: Excel File read/write
Hi,
This "AxImp.exe not found" error has been discussed and solved here:
task-failed-because-aximp-exe-was-not-f ... tml#p51871
task-failed-because-aximp-exe-was-not-f ... tml#p51940
Hope this helps?
This "AxImp.exe not found" error has been discussed and solved here:
task-failed-because-aximp-exe-was-not-f ... tml#p51871
task-failed-because-aximp-exe-was-not-f ... tml#p51940
Hope this helps?
Pavel Kudrys
Ranorex explorer at Descartes Systems
Please add these details to your questions:
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
Re: Excel File read/write
Hi,
I don't see 'Microsoft Excel XX.X Object' Library under 'COM' tab while trying to add as reference. I am using Ranorex 9.0 ver.
Can you please tell me where i can find and how can i add?
"i have also added the excel object in the COM reference library.
i have reinstalled Win SDK."
@maamer -> Can you please mention the steps?
I don't see 'Microsoft Excel XX.X Object' Library under 'COM' tab while trying to add as reference. I am using Ranorex 9.0 ver.
Can you please tell me where i can find and how can i add?
"i have also added the excel object in the COM reference library.
i have reinstalled Win SDK."
@maamer -> Can you please mention the steps?
Re: Excel File read/write
You can try ZetExcel. I think it will help to you.