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 |
how will b the questions if we keep one QTP project in CV.please tell me iam attending an interview.
Please explain about unicode compatibility in QTP. how we can able to use it. Please help me
how to do spell check in QTP? reply please
I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format, as i'm not in a possition to afford any 'Fee' to join in any institutions. Hence, if possible, kinldy mail PDF file to my mail-ID: chakri_avala@yahoo.co.in Regards, Chakradhar Yadav.
95 Answers Cap Gemini, Citrix, CTS, IBM, Logistics, QA InfoTech,
hi, In A Table there are some columns and dynamic rows and in each row in first column there is a link with name. upon clicking on that link it will show some details. write the vbscript to check that link without descriptive programming?
In the Hybrid framework, data can access the database, excel file, XML etc. Is it true?
how to export the result to notepad....for example i want to enter the user name and pass word and clicking on login button ......once you click on login button the corresponding page will open ...in that page you having one list box ...here you can get either success or failure ........friends here i want export the message what ever i got either success or failure .....how to export the result to note pad
can u expect, major bugs in NET BANKING Project? Modules Transaction Module, Customer Relation Module.
UFT 12.02 which ALM version will support
Hoe can we do retesting using functions please give the code for it using login page
what is batch testing?
In how many ways we can add check points to an application using QTP.