How to export(copy) the entire webtable from the webpage
into Excelsheet? using Vb scripting
- 9 Answers
- 26801 Views
- I also Faced
- E-Mail Answers
Answer Posted / raj
Please try this code. It will save the whole WebTable
content in the form of excel sheet.
Environment("Peportpath")="C:\Result.xls"
a=Browser("Google").Page("Google").WebTable
("index:=0").GetROProperty("outerhtml")
Set FSO = CreateObject("Scripting.FileSystemObject")
Set WriteFile = FSO.CreateTextFile( Environment
("Peportpath"), True)
writeFile.writeLine(a)
writeFile.close
| Is This Answer Correct ? | 9 Yes | 1 No |
Post New Answer View All Answers
Can any body please tell me the steps of keyword driven frame work in qtp. My mail is saswat445@gmail.com please send some materials on keyword driven testing in qtp. thanks a lot...
what are the issues we will get when there is migration from QTP 8.2 to QTP 10.0? Is there any problem in executing scripts of 8.2 on 10.0?
How do you test DLL files using automation Tool QTP?
www.icici.com ,after this.. home page wll came, in this page what r the items we r going to test for manual and what are items we r going to test for QTP... explian clearly with example
How can you identify the browser and its information using the qtp script?
What r the different filters in defect in quality center
How to use setroproperty?
Difference between action & Reusable action?
How to test background color and dynamic images during run time can you put the check point for moving objects?
What is recovery scenario manager? When you go for recovery scenario manager?
Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...
PLEASE TELL ME WHEN DO YOU USE THE OBJECT SPY AT RUN TIME
desribe a situation where u faced a stressful situation and how did u cope with it
How to attach a file to TD?
What is data driver in qtp?
