Open XML in excel problem

Discussion in 'XML' started by dermot_o_loughlin@yahoo.com, Jun 9, 2005.

  1. Guest

    Hi all,

    I have a problem opening xml in excel. If there are 2 or more rows in
    the xml document it opens up fine in excel and shows headers. If there
    is only 1 row in the xml document the headers do not get shown. Here is
    some example xml:

    1 Row
    =====

    <?xml version="1.0" standalone="yes"?>
    <NewDataSet>
    <Table>
    <PropertyOwner_Id>232</PropertyOwner_Id>
    <Propertyowner_MaritalStatus>Not
    Known</Propertyowner_MaritalStatus>
    <Propertyowner_FolioNumbers />
    </Table>
    </NewDataSet>

    2 Rows
    ======

    <?xml version="1.0" standalone="yes"?>
    <NewDataSet>
    <Table>
    <PropertyOwner_Id>317</PropertyOwner_Id>
    <Propertyowner_MaritalStatus>Not
    Known</Propertyowner_MaritalStatus>
    <Propertyowner_FolioNumbers />
    </Table>
    <Table>
    <PropertyOwner_Id>318</PropertyOwner_Id>
    <Propertyowner_MaritalStatus>Not
    Known</Propertyowner_MaritalStatus>
    <Propertyowner_FolioNumbers />
    </Table>
    </NewDataSet>

    Any Ideas,
    Dermot.
     
    , Jun 9, 2005
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,548
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  2. viza
    Replies:
    0
    Views:
    671
  3. eddie wang
    Replies:
    0
    Views:
    422
    eddie wang
    Oct 3, 2003
  4. sed_y
    Replies:
    0
    Views:
    1,037
    sed_y
    Feb 15, 2012
  5. JaxDawg

    Open XML in excel with javascript?

    JaxDawg, Jan 29, 2008, in forum: Javascript
    Replies:
    4
    Views:
    246
    JaxDawg
    Jan 30, 2008
Loading...

Share This Page