Microsoft Office Tutorials and References
In Depth Information
Importing and exporting XML data
To export XML data, click any cell in an XML table and then, on the Developer tab, click
the Export button to display the Export XML dialog box. Navigate to the folder in which
you want to export your data, enter a name for the file, ensure that the Save As Type field’s
value is XML Files, and click Export.
For programs to process XML data properly, developers must create a formal model of the
data’s structure. That model is called a schema. The schema for the Exceptions data
collection is as follows.
<?xml version=”1.0”?>
<xs:schema xmlns:xs=”http://www.w3.org/2001/XMLSchema”
targetNamespace=”http://www.w3schools.com”
xmlns=”http://www.w3schools.com”
elementFormDefault=”qualified”>
<xs:element name=”exception”>
<xs:complexType>
<xs:sequence>
<xs:element name=”Month” type=”xs:string”/>
<xs:element name=”Category” type=”xs:string”/>
<xs:element name=”Exceptions” type=”xs:integer”/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
Toward the bottom of the schema’s text are the elements for Month, Category, and
Exceptions, plus their data types. Creating a schema is a technical challenge that’s beyond
the scope of this topic, but Excel can create a schema from your XML data for all but the
most complicated data sets.
In this exercise, you’ll display the Developer tab of the ribbon, import XML data into a
workbook, create a schema based on the structure of the data, and then export the data to
another XML file.
 
Search JabSto ::




Custom Search