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
What are the automation metrice in your project?
When Recovery scenario actually starts while testing the application?
How to create scenario selector
Explain the difference between check point and output value?
How you can delete excel file in qtp?
How to Get the Run-time value of an object under that web app under Test to the local data table sheet of that Action?
What is the framework your company is following. What is the reason. Explain why key word driven frame work is chosen.
Hi All, we are using QTP Automation Scripts to test SAP. I recorded QTP Automation Scripts in English-based SAP GUI. Now we have to test a French-based SAP sytem and use the same scripts. The QTP scripts are failing when executed on the French-based SAP System due to Object Recognition Issues. What can we do? Do I re-record the scripts in the French-based SAP system?
give me the code to save all messages of inbox of gmail into a folder and notepad
Object repositories types, which and when to use?
Hi frens! I am testing VB project with MS Access database. At add button click my record is storing in data table and it is shown in datagrid. So at Delete button click i want to check datagrid rows 9before and after delete). so how can i do it using descriptive programming?
Hi. I have completed B.TECH(CS) , But I will go to "SECURITY CONSOLE OPERATING" [C.C CAMERA abservation]. IF interviwer asks " Why you choose this job ?" What we will say? urgent.........................urgent...........
What is use of object spy?
How to analyzing test results using quicktest professional (qtp)?
1. wat are the main diff b/w QTP 8.0 AND QTP 9.2 ( not user interface) 2. wat is the meaning of Keyword in keyword driven frame work? 3. how u will handle the unknown errors while exucution. (not recovery scenario)