Validating an xml schema
Any compilation errors are also shown with red wavy underlines.
You validate XML data against an XML schema to ensure that any XML data that you import to or export from one or more cells in a mapped range in a worksheet conforms to the XML schema in the XML Source task pane.
Although a full treatment of XML Schema is beyond the scope of this tutorial, this section shows you the steps you take to validate an XML document using an XML Schema definition.They use a simple XML Schema definition to validate personnel data stored in an XML file.) At the end of this section, you'll also learn how to use an XML Schema definition to validate a document that contains elements from multiple namespaces.To be notified of validation errors in an XML document, the following must be true: Because JAXP-compliant parsers are not namespace-aware by default, it is necessary to set the property for schema validation to work.The XML Editor checks XML 1.0 syntax and also performs data validation as you type.The editor can validate using a document type definition (DTD) or a schema.Note that when validating a document the target namespace of the document must match the target namespace of the schema in the schema set. In the code example that follows, the schema above is added to the Xml Schema Set Schemas property of the Xml Reader Settings object.