Visual Basic

nhsal69 wrote:

I'm a complete nube to this but I need a piece of code that will do the following:

nhsal69 wrote:

Put them somewhere (bearing in mind that an Excel doc is limited to 52000 ish rows)

nhsal69 wrote:

The XML data is in the form below; there is one for each folder and there are 10's of thousands of them.

You read the XML in with 'xmldocument.load(path)' 

Your first element = 'Folder'
This element has 2 attributes: 'fullpath' and 'IsFilesNode'

Your second element = 'Name'
This element has NONE attributes so you'll have to read the 'InnerText' of the element to get your data

...

nhsal69 wrote:

Is there a way of ignoring all the other stuff and just getting what I'm after, I dunno masking it out or something??

Dim odoc as new system.xml.xmldocument
odoc.load("path to the xml file goes here")

dim fullpath as string=""
dim node as system.xml.xmlnode= odoc.selectnode("Folder")
fullpath = foldernode.attributes.getnameditem("fullpath")

dim name as string
node = odoc.selectnode("Name")
name=node.innertext

nhsal69 wrote:

Dim node As System.Xml.XmlNode = odoc.SelectNodes("Folder")

nhsal69 wrote:

fullpath = foldernode.Attributes.GetNamedItem("fullpath")

Dim node As System.Xml.XmlNode = odoc.SelectSingleNode("Folder")

Try
           Dim odoc As New System.Xml.XmlDocument
           odoc.Load("c:\temp\text.xml")
           Dim node As System.Xml.XmlNode = odoc.SelectSingleNode("Folder")
           Dim fullpath As String = node.Attributes.Item("fullpath").Value
           node = odoc.SelectSingleNode("Name")
           Dim name As String = node.InnerText

           Label1.Text = fullpath & "     " & name
       Catch ex As Exception
           MessageBox.Show(ex.Message)
       End Try