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
Describe how Smart Identification is used
Hi I am new to QTP. can u please answer to my qus... suppose 3 excel sheets are there * we are trying to check for login credentials for a page. userid from excel1 , password is from excel2 whether the page is opened or not that checkpoint is result is should be stored in excel 3.... this qus i have faced in IBM technical round... please tell script for above query ... please please
Hi. please provide license key for QTP 9.2, I have windows XP on my machine Thanks in Advance, moreshwar
Where is the resultset of a sqlquery (which is fired by rsobj.open sqlquery,xxxx,xxxx) stored ?
What is the difference in the global and action sheet in qtp?
what are the mandatory properties for a tex boxc (scenario?)
How to explain a banking project in interview as a test engineer???
I want to do Certification course in QTP. For this I request you to suggest the best Tutorial in PDF format. Hence, if possible, kinldy mail PDF file to my mail-ID: sushmapokhriyal79@gmail.com
How to execute a winrunner script in quicktest professional?
What is the difference between rational rose and QTP?
What are the differences between qtp and winrunner?
How to capture all the data of a webtable, weblist and combolist using QTP?
Hi Friends, How many types of Data Bases available in market... What is the diff. while using Syabase and Oracle in a Project... ? and what is the main diff. of Syabase and Oracle databases... ? Thanx in advance..
How many ways is to parameterize the value?
What is the registration process and examination fees?