How to export(copy) the entire webtable from the webpage
into Excelsheet? using Vb scripting
Answers were Sorted based on User's Feedback
Answer / vikas sachdeva
For this first u need to add a webtable in the object
repository and use this line
dim xl
set xl=createobject("Excel.Application")
xl.workbooks.open "c:/book1.xls"
set nsheet=xl.sheets.item(1)
row=Browser("browser").page("page").webtable
("table").getroproperty("rows")
cols=Browser("browser").page("page").webtable
("table").getroproperty("cols")
for i=0 to row-1
for j=0 to col-1
val=Browser("browser").page("page").webtable
("table").getcelldata(i,j)
nsheet.cells(i,j)=val
next
next
Is This Answer Correct ? | 18 Yes | 3 No |
Answer / rentalavdml
Can u be clear in the question you mean copy the contents
of the webtable into excel or you need the whole webtable
object into excel
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / 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 |
Answer / yogesh
Well,
I think you can copy all webtable (the table that is
displayed on your test application) values into runtime
table or datatable using two simple for loop and then
export the runtime table to excel file with the command as
mentioned by Shridhar.
I havent written any such script as of now. but will post
it here when I write it.
Thanks,
Yogi.
Is This Answer Correct ? | 1 Yes | 1 No |
Sridhar thanks for the response. My question is I wanted to
use the runtime webtable clomuns and rows as input to the
another application during run time.
I have one application when we run with some inputs will
get the results as a webtable format in the web
application. I wanted to use those inputs as a input to
the another application during runtime.
Please let me know if your not clear with my question.
Thanks in advance.
Is This Answer Correct ? | 1 Yes | 3 No |
Answer / jay prakash
As QTP Supports Data Corelation very well.. So the output
from one obj/table can be used as input to another
obj/table. As Yogi explained... you capture your values in
the runtime data table and use it as the input to ur
requirement. Simple Data Driven testing strategy will help
you.
Is This Answer Correct ? | 0 Yes | 3 No |
Answer / sridhar
Use DataTable.export('path of the x.ls') method and write
all the contents into excel file. Hope this helps else letm
e know.
Sridhar.
Is This Answer Correct ? | 1 Yes | 5 No |
which tpye of exceptions mostly do we face in QTP
What are the advantages of qtp?
There is a table with 4 columns and 10 rows, how to write the script to display the first column records using qtp? can anybody help me with script?
How to invoke QTP through VBscript?Send me full code along with description of the code.Thanks in Advance
wht is the difference between action and functio?
Explain the keyword createobject with an example.
anyone can explain the following concepts. 1.diff b/w Linear and modular framework 2.diff b/w keyword and hybrid framework
what is the purpose of SetTOProperty Method?
1 Answers Cap Gemini, iGate, Wipro,
1. Pls can anyone give me the descriptive programing script to find the number of edit boxes in a login window in flights reservation (windows application only not web). 2. Using descriptive programing, how do you handle changing URLs. Pls anyone, very urgent
what is spy, and how can u use?
i have .xls,.txt,.doc files are there (together). i want find only .xls file among them? how can we write function?
I hav installed QTP8.2, im working on webapplication, while running the script giving error msg like "QTPro.exe generated errors and will be closed by windows. You will restart the program. An error log is being created". Pls anybody what is the problem, what i have to do for this? Thanks...