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
Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance
Is any limitation to xml checkpoints?
How do you capture tooltip using QTP?
What are the methods of the TextStream object that are used for reading from a text file?
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...
Describe synchronization point.
Discuss the QTP Environment?
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
How to connect to a database?
What are the various automation frameworks available in qtp?
hi frinds i need help .i have 4 + yrs exp in testing and nearly 2 yrs exp in QTP and QC .currently iam working north fast 2 yrs iam looking for job in south is there any openings plz letme know my mail id is pbre1980@gmail.com
wht is Manual Testing Frame work. Pls anybody can give appropriate answers
What is RTM (require ment tracebulity marix) fromate?
what are all the fileds present in object repository?
Hi, I'm a beginner in QTP and planning of a certification in QTP, but have no idea about it :P. Could anyone please tell me what certifications that a QTP- beginner can take? What is the fees and the syllabus for the certification? Please reply soon. Thanks Vidhya