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:
XLSheetObj.cells(rowno,colno).value
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / pravati
set excel=createobject("excel.application")
excel.application.visible=true
excel.workbook.open("path of the excelsheet")
set mysheet=excel.activeworkbook.worksheets("sheet name")
value=mysheet.cells(row no,colmn no).value
msgbox value
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ram.polavarapu
'count the number of colums
cc=browser("").page("").webtable("").columcount
'count the number of rows
rc=browser("").page("").webtable("").columcount
for i=1 to rc
for j=1 to cc
'to retrieve all data from excel sheet
n=browser("").page("").webtable("").getcelldata(i,j)
print n
'for example we need to retrieve from 2-row 5-colum
m=browser("").page("").webtable("").getcelldata(2,5)
print m
Is This Answer Correct ? | 2 Yes | 4 No |
You have an application version 1 with 5 combo boxes, Developers develop version 2. Here they replaced bottom 3 combo boxes with each other. While executing the Test script for version1 no errors. When we execute the Test script for version2 that QTP showing the error message "Object not identified" remember no property changed in version 2, ordinal identifier also disabled. Find what properties might change here in this scenario
suppose u have two send buttons(same width,height,font) on an application write a descriptive programming
hi what is the use of "dim" in automation objective model or any where what is the use of "dim" plz tell me
hello all i need some good sites or blogs which give info abt vb script with examples n real time scenarios.just like tutorials as i m new to qtp n vbscripting. its urgenttt
You will receive the mail in your outlook from client at night time to go ahead for the execution. Based on the mail you need to trigger the batch run. What is the QTP Code for this?
In Keyword driven frame work you have write 30 test case for one scenario,in which 10 test cases are failed while executing.client asked you to execute only the failed test cases. HOw can you execute only failed test cases
What are different versions in Win Runner ,QTP ,Load Runner and Test Director till now and atleast please let me know new features for each version. Ex QTP8.2,QTP 8.5.QTP9.2 supports Mozilla 2.0
What is the extension of script and object repositary files?
HO DO U CALL A ACTION?
In my script there is a link(e.g. 'My Page') when I execute the script sometimes(not every time) QTP throws an error that "My Page(as link)" not found. Pleaase tell me where I need to update
How to execute a WinRunner Script in QTP?
How to import the Test Results in QTP to an Excel sheet