Fetch XML data and place in excel.

Other Mainframe related questions which attracts you and there is no suitable Forum you find for it and related FAQs.

Topic author
Vibha
Registered Member
Posts: 31
Joined: Tue Jul 16, 2013 7:35 pm

Fetch XML data and place in excel.

Postby Vibha » Fri Jul 14, 2017 8:14 pm

Hi all,

I need to automate one test scenario. As a first step, I need to fetch data from a datset which is an XML and place in an excel sheet. Please advise if some one has done some thing similar or have an idea.



Online
User avatar

Robert Sample
Global Moderator
Global Moderator
Posts: 1256
Joined: Fri Jun 28, 2013 1:22 am
Location: East Dubuque Illinois
Has thanked: 2 times
Been thanked: 90 times

Re: Fetch XML data and place in excel.

Postby Robert Sample » Fri Jul 14, 2017 8:19 pm

First, this is not a mainframe issue so why are you asking on a mainframe forum?

Second, you did not specify where you are "fetch"ing the data from. Even if the data is coming from a mainframe, that does NOT make this a mainframe issue. If the data is on a mainframe, FTP is the usual way to pull data from a mainframe to a PC.

Third, Google is your friend so have you Googled excel xml to see what is on the Internet? I did and got back about 21,200,000 results so there is LOTS of material you need to start reading.




Topic author
Vibha
Registered Member
Posts: 31
Joined: Tue Jul 16, 2013 7:35 pm

Re: Fetch XML data and place in excel.

Postby Vibha » Mon Jul 17, 2017 12:27 pm

The file with XML data is a dataset on mainframes. That's why I thought it's a mainframe issue.




nicc
Global Moderator
Global Moderator
Posts: 542
Joined: Wed Apr 23, 2014 8:45 pm
Been thanked: 11 times

Re: Fetch XML data and place in excel.

Postby nicc » Mon Jul 17, 2017 12:59 pm

Your first step is to get the data from the mainframe to the server. As Robert has stated you do this with FTP. Your shop is probably doing this sort of thing already so you need to go to someone who has experience of this in your organisation because they will be able to help you with the control statements applicable to you place of work.

Your project leader should have advised you of this in the first place in the design document.


Regards
Nic


Return to “Other Mainframe Topics, Off-Topics, FAQs.”

Who is online

Users browsing this forum: No registered users and 0 guests