Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
When iam trying to import sheet to the QTP Global data
table at the run time using the Importsheet method.It is
able to import the sheet but no data is present after the
import due to which the test is failing.Could anyone
suggest what should be done.
When I open the actual excel sheet data is present and is
not corrupted.
- 2 Answers
- 6729 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / venkat
hi first u open excel file on your desktop,fill the data
datatable.addsheet"venkat"
datatable.importsheet"give here your desktop excel sheet
path",1,3
this is 1 is global sheet and 3 is new excel sheet, try it
on your qtp ok
thanks & regards
venkat
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / esu
chick excel workbook extention for".xls". other then .xls we
cann't.
| Is This Answer Correct ? | 1 Yes | 0 No |
How can we change the .mtr file to .tsr file and vice-versa
How to invoke Mozilla from QTP thru VB Script
is qtp 9.2 create the scripts with the application run on mozilla firefox browser?
Pls explain me the difference between ........ Description.Create and CreateObject
which tpye of exceptions mostly do we face in QTP
What is Associate Repository in QTP 9.2 ?
I want to execute 1st row of the local sheet and 3rd row of the global sheet parellely. write script to execute
i have two questions for regular expression :- Q1. I have date pattern eg-29/11/2011 29-11-2011 29.11.2011 Que- if any separator is there between date,month and year pattern should match else it should not match eg- pattern should not match in case of 2911-2011 Q2. let say i have a string and there is a number in between of that string eg.-Amount 30002.234 successfully credited to your account . now i have to match this pattern in such a way that even if decimal is not there pattern should match ,how i will do this using regular expression
hai, i completed my b.tech in 2010 with 62.3%. i having knowledge on manual testing and Qtp. i want Relavent experience in testing.watever may be d salary i dont bother..I just want to gain knowledge. i dont have good communication skills.
How can i click on any Excel sheet's "H" column with out writing coordinates Ex:Window("Book1").WinObject("Book1").Click 498,14 I dont want to give coordinates like 498,14 Can i open "H" column by writing like Ex:Window("Book1").WinObject("Book1").Click "H" or Ex:Window("Book1").WinObject("Book1").Click "H","1" or Ex:Window("Book1").WinObject("Book1").Click H,1 If i want to click on "Sheet3" of an excel sheet, Can i open like Ex:Window("Book1").WinObject("Book1").Click "Sheet3" Please help me any one
In QTP I have a parameter in a datatable that is a sentence. I need to take the last word from the sentence and enter it into a field in a web application. How can I setup a parameter to enter in just a portion of the parameter (last word of the sentence) instead of the entire paramater (whole sentence).
where the log files stored when using QTP? plz send answer to me ........
WinRunner 
