Import & export XML data, XML maps and schema in excel

This video assignment focuses on the use of Excel in manipulation of XML documents. A brief introduction to XML is given at the start of the video. XML is a complex machine readable document with well-defined schema. The drawbacks of editing such an XML document in a text editor, say notepad is discussed. EXCEL can be used as a powerful tool to edit XML documents. In this video, an overview of XML schema, and maps are provided. Automatic XML schema generation when importing XML files is discussed. The pitfalls of importing different schema into the same excel worksheet, refreshing XML data from external sources, are discussed. Finally, the steps to export the excel data table to an XML document is discussed.