Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How to retrieve particular cell data in excel sheet ?without importing method.

Answers were Sorted based on User's Feedback



How to retrieve particular cell data in excel sheet ?without importing method...

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

How to retrieve particular cell data in excel sheet ?without importing method...

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

How to retrieve particular cell data in excel sheet ?without importing method...

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

Post New Answer



More QTP Interview Questions

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 ?

6 Answers   Kanbay,


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...

5 Answers   NTT Data,


What is difference between web object and web items

2 Answers   Patni,


Suppose I created one object as virtual object? That object is applicable to that test? Or all the tests?

0 Answers  


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

3 Answers  






Can anyone please tell me how to select next 5th business date from calendar using QTP/UFT ?

1 Answers   Cigniti Technologies,


how qtp handles customised object

1 Answers  


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 krishnuvk@yahoo.com

0 Answers  


What is the difference in between function and sub as well as give some code of both

1 Answers   Wipro,


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

0 Answers   IBM,


How to return a value from a fn, if it has more than one value how to return

3 Answers   Verizon,


how to convert 100 into hundred repees only and viceversa

0 Answers  






Categories