What is the XML file and how does the XML file open

XML is a shorthand for extensible Markup language, an extensible identity language. Now teach you how to open XML files and software.

The easiest thing to do is to open it with an Excel form. You can also open an XML document with Netscape 6来, and you can also right-click "View Source file", and when you open an XML document with Netscape 6, the browser will display the root element and the child element with colored code.

　　How to open a file in Excel

When you open an XML file in Excel, you are prompted to select one of the following methods to import the XML data: As an XML list, as a read-only workbook, using the XML Source task pane to open the file as an XML list.

When you open an XML source, Excel looks for the markup for the XML style sheet (XSL). XSL describes how data is displayed. If a corresponding tag exists, Excel prompts you to choose whether to apply a style sheet. If you choose to apply XSL, the XSL will indicate how the data is displayed, and in this case the rest of the information in this section of this article will no longer apply.

If you do not have an XSL tag, you receive the following message:

The specified XML source does not have a reference schema. Excel creates the schema based on the XML source data.

Excel then imports the data from the XML source. If the XML data contains duplicate fields within an element, Excel distributes the data across multiple rows. Each row contains a unique dataset. This can cause small datasets in the XML to appear as many rows in Excel.

　　Open a file as a read-only workbook

If you choose to open the XML source document as a read-only workbook, the first tag of the element is used as the caption and placed in cell A1. The rest of the tags are sorted alphabetically and placed in the second row. When you open the Weather report example in the previous section as a read-only workbook, the data is arranged in the following column header list:

/area/city

/area/country

/area/region

/area/state

/date

/measurements/h-index

/measurements/humidity

/measurements/skies

/measurements/temperature

/measurements/uv-index

/measurements isibility

/measurements/wind/direction

/measurements/wind/windspeed

/time

If you have a dataset, the data for each column is placed on the third row of the spreadsheet. If the XML data contains duplicate fields within an element, Excel distributes the data across multiple rows. Each row contains a unique dataset. This can cause small datasets in the XML to appear as many rows in Excel.

　　Use the XML Source task pane

The schema of the XML data file is displayed in the XML Source task pane. You can then drag the schema elements onto the worksheet to map the elements to the worksheet.

If you open an XML data file that does not refer to a schema, Excel infers the schema of the XML data file.