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
Can any one send me the QTP Basic Coding Samples?
what is object and child object.. explain ..if possible give some example for better understanding ..
What is a quick test professional?
in qtp if we record a object and we record the object using virtual wizard then by which way the object is recognized that means recorded
What is difference between Recording time object identification and Run time (Execution) time.
if there is a web table of having row and colmns.a button is placed at 2nd row's 3rd column which is worked for both edit and delete..how to write script for the button to test both operation on the web table using desriptive programing.. plz help me on script wheather using getroproperty Q2)what is the command for taking valiue from a web table in qtp
Pls can anybody send me the Recent Technical and Interview Questions Which were asked in IBM(QTP)Automation PLZZZZZZZZZ
how to i add the values using the check points property?( i.e valid data(for valid data it's giving the footer message:value is added) and for invalid data: special chars, spaces,Duplicates and null values (in my page when ever we enter special chars, spaces and null values, it's giving the proper warning message and for Duplicates it's giving the footer message:"value already exists)?
wht type of User defined functions or Java Releated functions Do we write in VB scripting
I would like to directly import XL file and work on that XL file directly in QTp script in that XL sheet need to allocate workbench,XL sheet and generate two bar graphs automatically how to do that? plz let me know any answers?
Where we can use the analog mode and where we can use the low – level mode?
Is there anyway to automatically update the Datasource name in Database Checkpoints object when we migrate tests to a new release?
When using descriptive programming?
Functions call by reference and call by value. i want the diff b/n these 2 and how will be the script for this?in which situation we use these 2..?pls explain me clearly
If u r using library files (Instead of Check Points) , How do u do bitmap check ?