Working with XML
XML (Extensible Markup Language) is a universal language that enables you to create documents in which data is stored independently of the format so you can use the data more seamlessly in other forms. XML is supported in Office 2013 through Word, Excel, and Access. XML allows you to work with the familiar Office interface and create and save documents as XML, without ever knowing the XML language. When you work with XML, you can attach an XML Schema—a set of rules that defines the elements and content used in an XML document. XML schemas are created by developers who understand XML. After you attach a schema, you should change XML map properties before you map schema elements to cells in your worksheet.
Attach a Schema
Click ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
