Reading a String from excel with inverted marks
I am trying to read a string which is like : 'Please "Close" the page '. When I am reading from excel it is being read as 'Please ""Close"" the page.
I need to compare this string at some other place. Is this inherent issue with QTP reading from excel , Or Am i missing something .
I am reading the excel using the excel object and using the following command for the same
Req_Path = objXL.cells(XL_Row,XL_Col).value
Is there a workaround for it
Re: Reading a String from excel with inverted marks
I just verified, it is working perfectly.I am able to get as per your requirement. try creating a new excel sheet and see.