How to export(copy) the entire webtable from the webpage
into Excelsheet? using Vb scripting
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
Does QTP have any limitations?Can it work with all kinds of programming languages like java,springs,ajax ,hybernet?Also does it work well with windows 7.What are its other limitations
Define Environment Variable in UFT and its uses?
in data driven testing for performing operations which method is easy from manual test data,keyword view,or from database.and why?
please post the interview questions for QA position in FACTSET
how to prepared for first for the first interview?
How to remove associated function library?
What is the extension of the qtp local repository?
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 the element we r test for QTP... explian clearly with example
What are the main differences of qtp and win runner?
Explain types of output values?
How many add-ins comes by default with quicktest professional?
If the weblist is identified as webelement,and by clicking on webelement if the values are displayed,and if the values the values also identified as webelement.then how to fetch the values through script?
How many types of actions are there in quicktest professional (qtp)?
How many types of recording modes in qtp? Which will be used when?
What is 'sleep' in sync point?