Solved

XML Query - Result returned to Excel

Posted on 2010-09-02
2
402 Views
Last Modified: 2012-06-27
I have this list of phone numbers and I need to find out if they are local to me.

Is there anyway to take this list of phone numbers and run it against this XML Query and return the <islocal>N</islocal> part to a cell in excel? My list has 144 phone numbers (NPA/NXX's).

NPA1 and NXX1 is my originating end, and NPA2, NXX2 is the terminating end:

http://localcallingguide.com/xmlrcdist.php?npa1=416&nxx1=423&npa2=212&nxx2=733

Thank you,
Brandon
  <?xml version="1.0" encoding="UTF-8" ?>

  <!DOCTYPE root (View Source for full doctype...)> 

- <root>

- <rcdist>

  <npa1>416</npa1>

  <nxx1>423</nxx1>

  <rc1>Toronto</rc1>

  <region1>ON</region1>

  <v1>4981</v1>

  <h1>2488</h1>

  <lata1>888</lata1>

  <npa2>212</npa2>

  <nxx2>733</nxx2>

  <rc2>New York City Zone 01</rc2>

  <region2>NY</region2>

  <v2>4997</v2>

  <h2>1406</h2>

  <lata2>132</lata2>

  <distance miles="342" km="550" />

  <islocal>N</islocal>

  <effdate />

  <plantype />

  <calltype />

  <monthly />

  <note />

  </rcdist>

  </root>

Open in new window

0
Comment
Question by:bccramer
2 Comments
 
LVL 11

Accepted Solution

by:
jkpieterse earned 500 total points
ID: 33594297
See this small article on how to work with XML in Excel:

http://www.jkp-ads.com/Articles/XMLAndExcel00.asp
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

The Confluence of Individual Knowledge and the Collective Intelligence At this writing (summer 2013) the term API (http://dictionary.reference.com/browse/API?s=t) has made its way into the popular lexicon of the English language.  A few years ago, …
Healthcare providers, insurance companies and other covered entities trust eFax Corporate to transmit their most sensitive documents. eFax Corporate can help your organization implement a HIPAA compliant cloud faxing solution.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now