Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Feb 2006
    Posts
    504
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi,

    I have thousands xml files in different folders. I would like to import those xml files with the folder name to a excel worksheet. For instance, I have a folder call: Test1, inside of Test1 folder, I have two xml files with column: Name, Number.

    So I would like the excel worksheet display as the following after the importing:

    Name Number Folder Name
    Tom 123 Test1
    Anna 456 Test2

    Thanks in advance.

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,162
    Thanks
    47
    Thanked 976 Times in 906 Posts
    Unless the folder name is in the XML file you will have to add that manually, then sort as required.
    The XML import requires a template / library. I found this nice library in about 2 seconds.

    cheers, Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •