Interested to Buy Any Domain ? << Click Here >> for more details...
How to retrieve particular cell data in excel sheet ?without importing method.
- 3 Answers
- 5651 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 |
What is meant by Output Value in UFT?
.have you ever written compiled module? if yes , tell me about some of the function that you wrote.
why use Description programming? what is advantages and disadvantage of this methods?
Explain in brief about the qtp automation object model (aom).
What are the advantages of qtp?
Hello Everybody, How to maintain the page state in QTP. My scenario is: 1. I opened a notepad file. 2. Entered some text in the notepad file. 3.And changed the font type and color of the notepad file. And saved that. 4.Now next time when I will open the notepad it is showing the changed font type and color, rather than the default values. Please provide the code. Thanks, Gaytri
can we create recorset with out using database connection in vbscript?
tell me types of environment variables? what r they? explain details? pls give anwer any one?
what is impact analysis on regression testing?
Plz write the code, function will take the parameter as month number, i.e., numerical value, but it returns the last day of the month in string (weekday). example: input: function parameter: 3(march) output: thursday
Hi all, Recently i faced this question in infosys What is QTP architecture?? Is Architecuture and Framework are same?? Can someone please give clear understanding of this.
How does u create new test sets in TD?
WinRunner 
