Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve particular cell data in excel sheet ?without importing method.
- 3 Answers
- 5941 Views
- I also Faced
- E-Mail Answers
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 |
Suppose there is a link present somewhere in an excel sheet. Find the link and click on it. How to write a script using Excel application object in QTP?
what happen in object repository(shared)if we call an existing action from an external action ? and what happen in object repository(peraction)if we call an existing action from an external action ?
Under what conditions would you recommend QTP for future projects?
How to retrieve particular cell data in excel sheet ?without importing method.
what is the difference between development and testing
How to Analyze the Checpoint results by Checking Bitmaps?
What is the difference between a Function and Action in QTP?
How can we test existence of a particular word in scentence using QTP tool. Thanks in Advance!!!!!
How to use parameterization in qtp?
How can you merge two Object Repositories?
I have below user Defained function function AddTwo(ByVal a, ByVal b) Dim Ans Ans=a+b MsgBox Ans End function Now my question comes here...from given below methods which method is right to call above function?Which is Wrong and why? 1. AddTwo(2,4) 2. Call AddTwo(2,4) 3. AddTwo 2,4 4. Call AddTwo 2,4
How to load a object repository(using VBScript) ... very urgent....
WinRunner 
