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

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

6 Answers   ADP,


suppose u have two send buttons(same width,height,font) on an application write a descriptive programming

1 Answers  


hi what is the use of "dim" in automation objective model or any where what is the use of "dim" plz tell me

3 Answers  


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

2 Answers  


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?

0 Answers   CTS,


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

2 Answers   IBM,


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

1 Answers   DELL,


What is the extension of script and object repositary files?

7 Answers   Maveric,


HO DO U CALL A ACTION?

3 Answers   BirlaSoft,


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

3 Answers  


How to execute a WinRunner Script in QTP?

3 Answers   IBM,


How to import the Test Results in QTP to an Excel sheet

4 Answers   Sonata,


Categories