In my test, I need to import an Excel file to the Local DataTable(Action1) sheet and do some executions based on the data available in the Local DataTable sheet.
The test runs fine when I run for the first time. But when I run the same test again, the excel sheet is getting imported.I am able to view it at run time. But QTP is not extracting the values from the Local Sheet. I am gettin a message
"The <Column Name> column does not exist. But I am able to view the column in the Run Time Data table in the result viewer.
If I close QTP and relaunch it again, I am able to run the test successfully. But for only one time. The Next time when I try running the same test,the issue resurfaces.
Please let me know whether it is a known issue or a code issue and is there a patch available for the issue.
Re: Unable to get the value from the Local datatable
The issue might be related to excel formatting.
Open the Excel Sheet, Copy the entire contents of the sheet and paste it to another sheet. Note: When you paste, use paste special and select just "Values". Then use this new sheet and check if is okay.