www.webdeveloper.com
Results 1 to 5 of 5

Thread: XML List of lists in Excel or Calc

  1. #1
    Join Date
    Jul 2011
    Posts
    3

    XML List of lists in Excel or Calc

    Hello,

    Could you tell me how to map element of xml as list of list in Excel or Calc.
    examples, list of customers and list of items. 1 customer bought many items.

    Thanks.

  2. #2
    Join Date
    Nov 2002
    Location
    Baltimore, Maryland
    Posts
    12,270
    Separate tab for each Customer?
    “The power of the Web is in its universality. Access by everyone regardless of disability is an essential aspect.”
    —Tim Berners-Lee, W3C Director and inventor of the World Wide Web

  3. #3
    Join Date
    Jul 2011
    Posts
    3
    xml not csv, it use element as tag. not separated by space, tab or semicolon.

  4. #4
    Join Date
    Nov 2002
    Location
    Baltimore, Maryland
    Posts
    12,270
    Give us an example of the XML and describe how you want the Excel to look.
    “The power of the Web is in its universality. Access by everyone regardless of disability is an essential aspect.”
    —Tim Berners-Lee, W3C Director and inventor of the World Wide Web

  5. #5
    Join Date
    Jul 2011
    Posts
    3
    <?xml version="1.0" encoding="UTF-8"?>
    <Exds xsi:noNamespaceSchemaLocation="Exds.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

    <note_segment>
    <to>Tove</to>
    <from>Jani</from>
    <heading>Reminder</heading>
    <body>Don't forget me this weekend!</body>
    </note_segment>


    <customer_segment>

    <customer_id>
    <name>AAA</name>
    <tel>123</tel>
    </customer_id>

    <item_segment>
    <code>ITM1</code>
    <amount>10</amount>
    </item_segment>

    <item_segment>
    <code>ITM2</code>
    <amount>20</amount>
    </item_segment>


    <remark_segment>
    <remark>note1</remark>
    </remark_segment>

    </customer_segment>

    <customer_segment>

    <customer_id>
    <name>BBB</name>
    <tel>456</tel>
    </customer_id>

    <item_segment>
    <code>ITM3</code>
    <amount>30</amount>
    </item_segment>

    <item_segment>
    <code>ITM4</code>
    <amount>40</amount>
    </item_segment>

    <remark_segment>
    <remark>note2</remark>
    </remark_segment>

    </customer_segment>

    </Exds>


    to: Tove
    from: Jani
    heading:Reminder
    bodyon't forget me this weekend!

    name tel code amount remark
    AAA 123 ITM1 10 note1
    ITM2 20
    BBB 456 ITM3 30 note2
    ITM4 40

Thread Information

Users Browsing this Thread

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

Posting Permissions

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



Recent Articles