using XML with Excel

I have an Xml document that is quite strait forward. I can use a XSL document to format it correctly but I now have to add in 1 more element to the XML file that I do not want to show in the Excel document.

How do I go about doing this

My XML is as follows:
< xml version="1.0" encoding="utf-8" >
<AreasRoot>
    <room name="Entrance Hall">
        <item name="Doors">
            <roomIndex>0</roomIndex>
            <conditionBefore></conditionBefore>
            <conditionAfter></conditionAfter>
            <commentsBefore></commentsBefore>
            <commentsAfter></commentsAfter>
        </item>
        <item name="Security Door">
            <roomIndex>0</roomIndex>
            <conditionBefore></conditionBefore>
            <conditionAfter></conditionAfter>
            <commentsBefore></commentsBefore>
            <commentsAfter></commentsAfter>
        </item>
    <userDetails>
        <tennant
            address="123 Fake Street"
            name="Macca"
            landlord="DKKP"
            leaseDate="12/11/2004"
        ></tennant>
    </userDetails>
</AreasRoot>

I do not want the userDetails section showing in the Excel file

Answer this question

using XML with Excel

Mutozone
You might have better luck with the following forum:

Visual Studio Tools for Office
using XML with Excel

Answer this question