How to export(copy) the entire webtable from the webpage
into Excelsheet? using Vb scripting
Answer Posted / vikas sachdeva
For this first u need to add a webtable in the object
repository and use this line
dim xl
set xl=createobject("Excel.Application")
xl.workbooks.open "c:/book1.xls"
set nsheet=xl.sheets.item(1)
row=Browser("browser").page("page").webtable
("table").getroproperty("rows")
cols=Browser("browser").page("page").webtable
("table").getroproperty("cols")
for i=0 to row-1
for j=0 to col-1
val=Browser("browser").page("page").webtable
("table").getcelldata(i,j)
nsheet.cells(i,j)=val
next
next
| Is This Answer Correct ? | 18 Yes | 3 No |
Post New Answer View All Answers
Hi I know two types of testing processes. 1. Reaquirments stage,test design,code review's, Design review's, Test Plan, Test Cases design, test execution, Defect Reporting and tracking, UAT, Signoff. 2.Test Initiation , Test Plan, Test Design, Execution,Bug tracking, UAT, Sign off.
how to use the QTP choose the data from oracle? e.g. i input the identity card NO. this will be add new record in the database ,and now i want get this record's prime key.
Explain quicktest professional testing process?
i have asked earlier only one question how to test web application using QTp plz send me the answer quickly
Get the count of files of similar types from a folder.
What contains Data Driven Framework document in qtp?
How to customize checkpoints with parameters?
how to test Web application using QTP software
What is expert view and keyword view?
Dis advantages of XML checkpoint ?
Where should i find checkpoint and virtual objects's Object properties and values in the QTP 9.2 Means where checkpoints or virtual objects related data will store If i want to get the runtime object properties how can i use Getroproperties on Checkpoints
can anyone tell me from where i can download qtp demo or crack version
1.explain end to end process of qc,2.how many tabs are in qc9.0,qc10.0 3.what is review, how many reviews are following in aproject 4.how will you get the requirements 5.why do we choose testing 6.how to export tc's and requirements to qc through add-ins
Plz Explain AUTOMATION REFERENCE MODEL?
hi frinds i need help .i have 4 + yrs exp in testing and nearly 2 yrs exp in QTP and QC .currently iam working north fast 2 yrs iam looking for job in south is there any openings plz letme know my mail id is pbre1980@gmail.com