Microsoft Office Tutorials and References
In Depth Information
Don’t let the long set of closing tags at the bottom of the list fool you—the structure of the
data objects depicted in the schema isn’t that complex. Figure 26-4 depicts the schema’s
structure graphically instead of textually.
Figure 26-4. XML schemas are detailed, but not overly complicated.
Note You can display the XML Source task pane, which displays any schemas assigned
to a workbook, by clicking Data, XML, XML Source.
The first two lines of the listing are housekeeping details that tell the XML interpreter which
version of XML is used, which character encoding standard the data conforms to, and a refer
ence to the schema standards document online at the Wo rld Wide We b Consortium’s We b site.
<?xml version="1.0” encoding="utf-8” ?>
Watch Your Language
The utf-8 encoding scheme is used to represent relatively simple character sets such as
that used in American English. American English employs few accents (and then only on
borrowed words), which means computers can represent the entire character set (including
numbers, capital letters, punctuation, and certain special characters such as spaces,
tabs, and so on) using only eight bits of data. For other languages that have differing basic
characters or use accents, you need to use another eight bits to represent all the possible
characters. The encoding scheme for most of those languages is utf-16.