03-31-2011, 08:54 PM
This is an interestinging Question.
Experts, please correct me if I am wrong, I believe "pUsename" is a LABEL used within a particular Datasheet and is always located on the First Row of the datasheet / Worksheet in Excel. QTP logically interprets it as a Column Name instead of using Excel Column Name.
If you try to open the Excel Doc externally, you will be able to view my explanation. Hence '=Global!A1' is correct the value is being worksheet "Global" Cell "A1". I believe Excel will not recognize as Column "A" unless you rename the Column naming convention within Excel.
Experts, please pitch in your comments if I am wrong. I would also like to understand the internal to this.
Thanks,
Subha
Experts, please correct me if I am wrong, I believe "pUsename" is a LABEL used within a particular Datasheet and is always located on the First Row of the datasheet / Worksheet in Excel. QTP logically interprets it as a Column Name instead of using Excel Column Name.
If you try to open the Excel Doc externally, you will be able to view my explanation. Hence '=Global!A1' is correct the value is being worksheet "Global" Cell "A1". I believe Excel will not recognize as Column "A" unless you rename the Column naming convention within Excel.
Experts, please pitch in your comments if I am wrong. I would also like to understand the internal to this.
Thanks,
Subha