The map, shown in the Source Task Pane in Figure 8.7, was created automatically when I opened the XML file. As you will see shortly, Excel provides several objects that allow your VBA programs to accomplish these same tasks.Įxcel also uses the provided (or created) XML schema to create an XML map that serves to map the elements in the XML file to specific ranges in the worksheet. For example, you can export changes to the list to the XML file, refresh the data in the list, edit the properties of the XML map, and more. You can manage the list and the data it contains from the XML selection on the Data menu and/or the Source Task Pane (see Figures 8.6 and 8.7).
MIAMI DENVER NDIANAPOLIS CLEVELAND DETROIT STLOUIS The following XML code defines the basic structure of the XML file opened in Figure 8.5-the data was omitted for brevity.įate E.dfc iiew Lnswt Fermât Lorfs final » 30 v jTJ / U ■ In addition, an asterisk marks the next available row for inserting data into the list. The list is highlighted with a blue border, and a filter (normally selected from the Data menu) is automatically applied. Figure 8.5 shows data from an XML document that describes a list of words and topics (something you might use in the project for Chapter 7). An Excel list provides additional features and formatting that makes it easy to identify and modify the list. When you open an XML file as a list, Excel adds the data to a worksheet and creates a list (normally created from the Data menu). Opening an XML file with no referenced schema. Selecting the data format when opening an XML file. You don't have to see the schema, or know how it describes your XML document, but you should know that it's there working in the background defining your data elements for Excel. If the XML file does not reference an existing schema document (.xsd file extension), Excel will automatically create one (you may be notified of this fact as shown in Figure 8.4) and store it internally with the workbook.
Please select how you would lite to open this file: ® As an XML list O As a read-only workbook O Use the XML Source taskpane Typically, you load the data into a worksheet as an Excel list in order to take advantage of the data management features a list provides. After selecting a file, you will be asked if you want to open the file as an XML list, read-only workbook, or to use the XML Source Task Pane (see Figure 8.3). To open an XML document from the Excel application, select File, Open and then choose the desired XML file (.xml file extension) from the Open dialog box.
0 kommentar(er)
