XML List of lists in Excel or Calc

**manofspider** · 07-14-2011 06:06 PM

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.

**Charles** · 07-15-2011 06:42 AM

Separate tab for each Customer?

**manofspider** · 07-18-2011 03:03 AM

xml not csv, it use element as tag. not separated by space, tab or semicolon.

**Charles** · 07-18-2011 05:06 AM

Give us an example of the XML and describe how you want the Excel to look.

**manofspider** · 07-18-2011 06:46 AM

<?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
body

on'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: XML List of lists in Excel or Calc

Thread Tools

Display

XML List of lists in Excel or Calc

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions