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
Create flight reservation login descriptive programing (Condition: Remove the value and substitute with a variable, and then call the validation from Excel) Plz help me....... very urgent.........
How to use checkpoints in qtp ?
Can we access the java methods in qtp. Because my requirement is to access the swt(for eclipse an it is java code) methods in qtp is it possible?
How will you handle java tree in qtp?
How to test login module with different username and password by using data driven testing in QTP?
How to start recording using quicktest professional?
I want to grow as a Automation Engineer,Kindly help me in clearing my interview that what interviewer looks for as a Automation Engineer. I am having three years of experience in testing.
how to test Web application using QTP software
What is the registration process and examination fees?
WAT IS DATA BASE AND XML CHECK POINT ?HOW TO IMPLEMENT IT ... GIVE PROPER EXAMPLE FOR IT
Is it possible to change the property value at runtime? How it is possible?
what is the difference between rational rose and QTP? WHICH TOOL IS BETTER TO LEARN? PLEASE SEND ME AT sana_50218@yahoo.com sandeep@epuratech.com
what is the hierarchy to use properties in descriptive programming
What are the steps involved in recovery scenario wizard?
What is TOM in QTP?