Copying data from HTML to Excel

[santhoshippili]

Hi All,

I am fairly a new user of QTP.

I have to copy the data in the web page to Excel.
Please help me...!

Note: The data was not present in Web tables.

[Arul]

Santhosh,

We get the value using of getrowwithcelltext() function. To get the row of the text.
Please clearly explain ur Requirement.

Thanks,
Arul.D

[santhoshippili]

Hi Arul,

My requirement is like this.

Our App generates 3 reports HTML,Excel and PDF respectively.
I have to compare the three reports with master data.
So what i planned is keeping the excel report as it is, I will prepare one more excel sheet with a specific format which i need to test.

I have to copy the data from HTML and PDF to two excel sheet where i can compare the data using any excel macro or conditional formatting or something else,

The main challenge for me is to copy the required data from HTML or PDF into Excel where i can compare it.

Please help me in this regard.

[santhoshippili]

Hey Arul,

I want the entire page to be copied into Excel, and i am not sure whether everytime my page has a constant string.

Let us assume, you typed something in google search like "Arul" and all the related info will be displayed in the search page.

I have to copy the entire search page into excel with the same format.

[Ankesh]

try this...

Code:

strPageValues=Browser("").Page("").Object.body.innertext

see if it works.

[santhoshippili]

Ankesh,

Thank for the Quick reply, then will it will get the unnecessary td,tr,br's etc.
i want to paste this into Excel via Global Data sheet.

Any Clues.
My Second reply will clearly explain the functionality exactly what i needed.

[ravi.gajul]

Hi Santhosh,
Ankesh's code will give you innertext ...i.e...it will not display the tags(td,tr,br's).

Regards,
Ravi