i am unable to import my test data in excel to data table as it throwing an error.
for the first run every thing is fine but from the second run onwards finding this weird behavior.
getting a pop up, Run Error:"the retrieve DataTable.Value operation failed. The <Column Name> column does not exist.
line #39:strdummy=DataTable.Value("Column name","sheet name")
at the end we get the run results viewer error:
"cannot create data table from file ' << path >>/default.xls'
QTP 11 and excel 2010.
OS: Windows server 2008 - SP2.
we have to close the QTP and reopen again to make it run.
but again getting the results error.
has any one faced these kind of issues?
when things gets harder ,the harder gets going
when i am getting the Run Error i can see the excel data is loaded in data table.
This happens due to excel formatting. Clear all formatting from your excel sheet and load it again.
can i select entire sheet and select the format as text, will that help?
thanks Raj for your quick update
it worked out for me... [img]/images/graemlins/smile.gif[/img]