Results 1 to 3 of 3

Importing XML issue

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2011
    Location
    US
    MS-Off Ver
    Excel 2010
    Posts
    2

    Importing XML issue

    I am trying to import an XML of a project plan into Excel. One row of data in the XML file is showing up in multiple rows in Excel. For example, the task name is in row 2, the start date in row 3 and end date in row 4. How do I get this to appear in one line in Excel?

    Thanks!

    Joe

    BTW -- Here's a snipet of the XML format:

    <Task><UID>1</UID><ID>1</ID><Name>Project Initiation</Name><Type>0</Type><IsNull>0</IsNull><CreateDate>2011-03-23T06:51:42</CreateDate><WBS>1</WBS><OutlineNumber>1</OutlineNumber><OutlineLevel>1</OutlineLevel><Priority>500</Priority><Start>2011-03-14T08:00:00</Start><Finish>2011-04-15T17:00:00</Finish>

    I used the XML Source pane to drag Name, Start and Finish into the workbook.
    Last edited by Leith Ross; 03-23-2011 at 04:10 PM. Reason: Added XML format and a little more info

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1