How to retrieve particular cell data in excel sheet ?without importing method.
Answers were Sorted based on User's Feedback
Answer / uday
The Question is to retrieve a cell value from Excel sheet.
The method which does this is:
|Is This Answer Correct ?||1 Yes||1 No|
Answer / pravati
excel.workbook.open("path of the excelsheet")
set mysheet=excel.activeworkbook.worksheets("sheet name")
value=mysheet.cells(row no,colmn no).value
|Is This Answer Correct ?||0 Yes||0 No|
Answer / ram.polavarapu
'count the number of colums
'count the number of rows
for i=1 to rc
for j=1 to cc
'to retrieve all data from excel sheet
'for example we need to retrieve from 2-row 5-colum
|Is This Answer Correct ?||2 Yes||4 No|
We developed 100 descriptive programms and put in running, in the midle if any descriptive program is stucked with some error? what will happend weather it will execute the remaining prg's or it will terriminate ?
If there are 100 checkboes in a page then how can we select 10th & 11th & 14th chexkboxes at once through descriptive programing in QTP using vb script. Please send the answers...
What is difference between web object and web items
Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?
how to write this script using descriptive programming? the script below is the script generated by QTP plz write the script using descriptive programming? plzzzzzzzz do answer thanku Browser("Welcome: Mercury Tours").Page("orkut - login").WebEdit("Email").Set "test123" Browser("Welcome: Mercury Tours").Page("orkut - login").WebEdit ("Passwd").SetSecure "475259b450e3d212bef4a5f5ce9d32ebcbf4" Browser("Welcome: Mercury Tours").Page("orkut - login").WebButton("Sign in").Click Browser("Welcome: Mercury Tours").Page("orkut - home").Link ("Logout").Click Browser("Welcome: Mercury Tours").Page("orkut - login").Sync Browser("Welcome: Mercury Tours").Close
Can anyone please tell me how to select next 5th business date from calendar using QTP/UFT ?
how qtp handles customised object
HI I want to know the detials of QTP certifications such as syllabus, study Materil etc. Can any provide me all these details?? my mail ID is firstname.lastname@example.org
What is the difference in between function and sub as well as give some code of both
How to run scripts 1,29,3,5,7,2 scripts using test batch runner in QTP.... Ie...I wanted to run scripts not in an order 1,2,3,4,5...like that How it is possible using test batch runner... I dont want hardcoded script
How to return a value from a fn, if it has more than one value how to return
how to convert 100 into hundred repees only and viceversa