ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Importing XML Data (https://www.excelbanter.com/excel-discussion-misc-queries/198671-importing-xml-data.html)

Rob

Importing XML Data
 
Hi, I have a large XML file with tons of data and everytime I try to open or
import it into Excel all I ever get is the Attribute/Type Names and Valuetype
data information but I never get the actual Data/Values of the Attributes.
Info Below.


Here's a sample of what I have...

<AttributeNode TypeName="ID"
ValueType="string"6984684687965456</AttributeNode
<AttributeNode TypeName="Description" ValueType="string"Count
Indicator</AttributeNode
<AttributeNode TypeName="Abstract" ValueType="string" /
<AttributeNode TypeName="Status"
ValueType="string"Complete</AttributeNode
<AttributeNode TypeName="Priority" ValueType="string"Low</AttributeNode
<AttributeNode TypeName="Owner" ValueType="string"TDCKLM</AttributeNode
<AttributeNode TypeName="Owner Organization" ValueType="string"Home
Office</AttributeNode


But I never get the information that's there...

6984684687965456
Count Indicator

Complete
Low
TDCKLM
Home Office



Is there something that I am doing wrong?


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com