Objective- Fetching Entire Web table data from application to external Excel sheet

[gopal.tikare]

Hi all,

Is it possible to extract entire web table data at a time to specific
excel sheet..???

Example:

I have one web table in my application with 100 Rows and 10 Columns.
Now i need to get entire table data (One Shot) from the application
and put all once in external excel sheet.

As I am familiar to fetch row wise or column wise but finding
difficult to get all the data one at a time.. Is there any way to get
the entire data..???

Note: I googled on the following phrase “Exporting entire web table
content from application to Excel sheet using QTP” but didn't get
anything that looked promising

Thanks,
Gopal

[Roman Zilber]

Hi,

Read the table values, populate it in data table, export. "Exporting entire web table
content from application to Excel sheet using QTP" - has is nonsense.
You can with the same success search for "automate entire application with one click". :)
Also try to search for "excel automation".

Roman

[Gmail]

Hi u can use the DOM object and get the whole table in one shot, as u will be pulling all the values with respective to the columns in to arrays. Try …it might work for u..

 

Thanks,

Sreedhar

9848871279

[Gopal Tikare]

Hi Sreedhar,

Thank for your Reply !!

I have not used DOM Objects till date. I don't have much knowledge on it... So kindly elaborate  how to use DOM Object and how to get the data from the Web table.

I used the below mentioned method to get the values but it fetches the entire web table content in the form of string which is very difficult to split using Delimiter and segregate the data into excel sheet.

Ex : Browser("XYZ").Page("XYZ").WebTable("XYZ").GetROProperty("innertext")

your help will be highly appreciated.

Thanks,
Gopal

[swapna patil]

Hi Sreedhar,

 

var = Browser("Personal Details Page").Page("Personal Details Page").WebTable("General Details").Object.innerText

 

I used the DOM method to get the values but it fetches the entire web table content in the form of string which is very difficult to split using Delimiter and segregate the data into excel sheet.

Thanks,

Swapnali

[Sedhupathi Gnanasundaram]

Hi Gopal,

Go through the below URL i hope you will get idea..

http://www.qtpsudhakar.com/2009/02/working-with-webtable-object.html 

Thanks&Regds

Sedhu

--
--
You received this message because you are subscribed to the Google
"QTP - HP Quick Test Professional - Automated Software Testing"
group.
To post to this group, send email to Mercu...@googlegroups.com
To unsubscribe from this group, send email to
MercuryQTP+...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/MercuryQTP?hl=en
 
---
You received this message because you are subscribed to the Google Groups "QTP - HP Quick Test Professional - Automated Software Testing" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mercuryqtp+...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.