Microsoft Office Tutorials and References
In Depth Information
Importing and exporting XML data
Importing and exporting XML data
By using HTML, you can determine how a document will be displayed in a web browser,
such as by telling Internet Explorer to display certain text in bold type or to start a new
paragraph. However, HTML doesn’t tell you anything about the meaning of data in a
document. Internet Explorer might “know” it should display a set of data in a table, but it
wouldn’t “know” that the data represented an Excel spreadsheet.
You can add metadata, or data about data, to web documents by using XML. Although
a full discussion of XML is beyond the scope of this topic, the following bit of XML code
shows how you might identify two sets of three values (Month, Category, and Exceptions)
by using XML.
<?xml version=”1.0” encoding=”UTF-8” standalone=”yes”?>
<ns2:exceptions xmlns:ns2=”http://www.w3schools.com”>
<exception>
<Month>January</Month>
<Category>2Day</Category>
<Exceptions>14</Exceptions>
</exception>
<exception>
<Month>January</Month>
<Category>3Day</Category>
<Exceptions>3</Exceptions>
</exception>
</ns2:exceptions>
XML is meant to be a universal language, allowing data to move freely from one program
to another. Excel might display those two sets of Exceptions data as rows of data in an Excel
worksheet.
14
 
Search JabSto ::




Custom Search