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
Through array we can execute the testcase how ? give me example
what are the utilities and drivers
What is keyword view?
Can anyone help.i need total excelsheet operations,shortcuts in testing environment from starting onwards....
What is object repository in qtp?
Explain actions in qtp ?
can anyone tell me what to say in interview when interviewer asks about "tell me about your framework in your project"?
Hi Friends, I worked with 8.2 not with 9.2. Please help me in this prob. I created one script and recorded some think and save as Test 1 then I opened process--open the object repository manager. Switch to file->save->give some name->save as Objectrepo1.tsr file. (This is the global repository file.) Then I went to object repository->tools-> associate repository ->click + icon ->open the previously saved Objectrepo1.tsr file. This is the global repository Now I created one more script and save as Test 2. In this script I am calling script with the Help of "Call of existing action" and I executed but QTP is not able to execute B’cos it is QTP is not able to read the Object Repository of Test 1. Please let me know why? Once I made Script 1 as a shared Obj. Repository so it would not give any Problem. Right?
how to test Web application using QTP software
Explain the features of quick test pro(qtp)?
Some time when i wanna learn the object i face issue like i am not able learn the object in proper manner... eg:for text bo on web page it should learn as webedit but some times it reads as winobject:internetexpoler-server, because of this i have to uninstall the qtp and re-install it again when i do this it reads the object perfectly.....plz suggest the soln
How will you handle java tree in qtp?
How many types of recording modes in qtp?
On what document base Descriptive programming is written if build is not yet ready ?
What is the difference between the design-time and run-time data tables?