New To UFT? Join the best UFT Training Online!

Micro Focus QTP (UFT) Forums › Micro Focus UFT (earlier known as QTP) › UFT / QTP Beginners v
Need to extract data from XML to excel in QTP

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Thread Modes
Need to extract data from XML to excel in QTP
rrdamuluri Offline
Junior Member
**
Posts: 6
Threads: 3
Joined: Nov 2010
Reputation: 0
#1
Not Solved 11-03-2010, 09:59 AM
Hi,
I need to extract some attributes values and element text data from
XML to excel.
Can some one help me.
Hierarch of xml elements is
on>programs>program>images>image>URI
I need to get an attribute TMSID from program element. And for each
TMS ID, need to get image elements category attribute and URI elements
text values. Need to save all this into an external excel sheet. And
for some of the program elements images/image does'nt exist.

Sample XML is attached


Attached Files
.zip   read.zip (Size: 1.12 KB / Downloads: 79)
Find
Reply


Messages In This Thread
Need to extract data from XML to excel in QTP - by rrdamuluri - 11-03-2010, 09:59 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,173 07-10-2017, 04:20 PM
Last Post: rajeevk7
  dtLocalSheet empty even though excel file contains data cantorre 2 2,235 05-10-2017, 12:47 PM
Last Post: vidhi
  Reading data from excel sheet serenediva 1 8,913 03-03-2017, 10:07 AM
Last Post: vinod123
  Extract and save a file from zip folder using VB Script karthicksri07 1 6,193 06-29-2016, 02:19 PM
Last Post: Ankesh
  qtp script for updating values in xml file automation2012 3 11,270 11-30-2015, 11:07 AM
Last Post: Lavanya N

Forum Jump:


Users browsing this thread: 1 Guest(s)