Let us look at a simple example of how the Exult XML Conversion Wizard can convert XML to a Microsoft Excel Spreadsheet (XLS). The XML for this example is quite simple and serves to illustrate how the data is handled. However, Exult can handle far more complex XML than is shown below.:

Here is the Microsoft Excel Spreadsheet generated by Exult for the data sample shown below.

<Customers>
    <Customer CustomerID="AROUT">
        <CompanyName>Around the Horn</CompanyName>
        <ContactName>Thomas Hardy</ContactName>
        <Address>120 Hanover Sq.</Address>
        <City>London</City>
        <PostalCode>WA1 1DP</PostalCode>
        <Country>UK</Country>
    </Customer>

    <Customer CustomerID="CHOPS">
        <CompanyName>Chop-suey Chinese</CompanyName>
        <ContactName>Yang Wang</ContactName>
        <Address>Hauptstr. 29</Address>
        <City>Bern</City>
        <PostalCode>3012</PostalCode>
        <Country>Switzerland</Country>
    </Customer>

    <Customer CustomerID="GREAL">
        <CompanyName>Great Lakes Food Market</CompanyName>
        <ContactName>Howard Snyder</ContactName>
        <Address>2732 Baker Blvd.</Address>
        <City>Eugene</City>
        <Region>OR</Region>
        <PostalCode>97403</PostalCode>
        <Country>USA</Country>
    </Customer>

    <Customer CustomerID="BSBEV">
        <CompanyName>B's Beverages</CompanyName>
        <ContactName>Victoria Ashworth</ContactName>
        <Address>Fauntleroy Circus</Address>
        <City>London</City>
        <PostalCode>EC2 5NT</PostalCode>
        <Country>UK</Country>
    </Customer>

    <Customer CustomerID="HUNGC">
        <CompanyName>Hungry Coyote Import Store</CompanyName>
        <ContactName>Yoshi Latimer</ContactName>
        <Address>City Center Plaza 516 Main St.</Address>
        <City>Elgin</City>
        <Region>OR</Region>
        <PostalCode>97827</PostalCode>
        <Country>USA</Country>
    </Customer>

    <Customer CustomerID="LETSS">
        <CompanyName>Let's Stop N Shop</CompanyName>
        <ContactName>Jaime Yorres</ContactName>
        <Address>87 Polk St. Suite 5</Address>
        <City>San Francisco</City>
        <Region>CA</Region>
        <PostalCode>94117</PostalCode>
        <Country>USA</Country>
    </Customer>

    <Customer CustomerID="WARTH">
        <CompanyName>Wartian Herkku</CompanyName>
        <ContactName>Pirkko Koskitalo</ContactName>
        <Address>Torikatu 38</Address>
        <City>Oulu</City>
        <PostalCode>90110</PostalCode>
        <Country>Finland</Country>
    </Customer>
</Customers>

Exult extracts data from the above XML into to a table of the following form. Note that primary and foreign key information has been removed from the output generated by Exult and a distinctive styling has been applied for display purposes.

Note the following important points about the extraction:

• Attribute information has been extracted to a column in a manner similar to the element information. For example, CustomerID in the above example XML is an attribute and has been extracted as a column in the table below.
• When no value is specified for a column within the XML, it is extracted with a NULL for its value. In the example XML above, customers AROUT, CHOPS, BSBEV or WARTH have a NULL value for the Region.

Customer

• Download
  a Free Trial
• Buy Now
  for US$150 $105
• More Details