| || |
QTP 10: Not able to set values in DataTable during Runtime
I am using a framework in which we have Test Data excel file. we are importing all the sheets into datatable and then executing the scritps based on the condition. I am facing issue in setting value in a DataTable using [DataTable.Value("Clo","sheet") = aab]. Although if I put a Msgbox it displayes the correct value but not writing in DataTable.
Can anyone help me on this?
Please let me know if more information is required,
Thanks in Advance
Just wondering if you had specified the row and column (along with the correct worksheet) where you wanted to write the value in the Data Table?
is "sheet" the actual name of the sheet?
What is the exact error you are getting?
As per documentation:
SheetID =The SheetID can be the sheet name, index or dtLocalSheet, or dtGlobalSheet.
Question 1: Is your Sheet creating column name Clo ?
Question 2: Is your Sheet with name "Sheet" is getting import correctly , also the name case of Sheet is proper ?
Tags for this Thread