Illustration

The table in B8:G12 is also data bound to an XML mapping object. The first column, titled "type", is associated with the XML Map named "expense-report_Map", specifically the attribute identified by the xpath expression /expense-report/expense-item@type pointing into the corresponding XML structure. In similar fashion, each of the columns in the Table correspond with elements or attributes in the related XML Map structure.

Additionally, cells B3:D3 and B6:D6 are each bound to a single, non-repeating element or attribute from the same XML Map structure. For example, cell B3 corresponds to /expense-report@currency.

In this way XML instance structures can be refreshed into the cells and Table region, and XML instance structures can be generated from the data in those ranges of the spreadsheet. In other words, XML structures can be imported and exported to and from the worksheet via the XML Mapping feature.