954,585 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Have something to say? Contribute New Article Reply to this Article

XML Issues

Hi All, i am trying to write an application that will take an XML file that has been saved from an XLS spreadsheet and display the data. I will be ok with how to display the data i just dont know how to get the data from the XML.

I have done a few google searches and the info i have found demonstates how to get the first layer of data, or will just display the whole thing is 1 big string.

the structure of the XML is below, I need the data from between the tags. there are also quite a few rows of this data as wel.

Thanks

<Row>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Job No</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Contractor</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">ETA</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Job Type</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Job Status</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Customer</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Site Service No.</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Site Contact</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Current User</Data></Cell>
    <Cell ss:StyleID="s21"><Data ss:Type="String">Contractor Ref</Data></Cell>
    <Cell ss:StyleID="s22"/>
   </Row>
leviathan185
Junior Poster
105 posts since May 2009
Reputation Points: 19
Solved Threads: 15
 
ShawnCplus
Code Monkey
Team Colleague
1,583 posts since Apr 2005
Reputation Points: 526
Solved Threads: 268
 

Thanks, I had already looked at that and it was giving me erros. I found the answer in the DOM. I overlooked that when i looked before.

Thanks

leviathan185
Junior Poster
105 posts since May 2009
Reputation Points: 19
Solved Threads: 15
 

This question has already been solved

Post: Markdown Syntax: Formatting Help
You