Open topic with left hand navigation

Attaching an XML Schema to an Excel Document

This topic provides detailed information on how to attach and XML schema to an Excel document.

To create a new layout file using Excel

  1. Open your Excel document.
  2. Choose Data > XML > XML Source…
  3. On the XML Source task pane (which should appear to the right of the application window), click XML Maps… to display the dialog for attaching a schema file to your workbook.
  4. If the schema you need is not already in the list in the XML Maps dialog, click Add… to browse for the file.
  5. Select the schema .xsd file corresponding to the document or register for which you are creating the layout.

    6. For more information on how to get a copy of the Proliance XML Schemas, see "Getting the Schemas".

    See also "Mapping Documents and Registers to XML Schemas" if you are unsure which schema file corresponds to a particular document or register.

  6. When you open the schema, a Multiple Roots dialog box prompts you to select the root node. Select the element representing the document.
  7. If a validation warning is displayed, click Yes to continue.
  8. Click OK when you have finished adding XML maps to the workbook.