Unsupported XML schema constructs

 Note   XML features, except for saving files in the XML Spreadsheet format, are available only in Microsoft Office Professional Edition 2003 and Microsoft Office Excel 2003.

Microsoft Office Excel 2003 supports importing and exporting XML data through a wide variety of XML schema constructs. However, there are some XML schema constructs that Excel does not support. The following list details the XML schema constructs that cannot be imported into Excel:

<any>    The <any> elements allows you to include elements that are not declared by the schema.

<anyAttribute>    The <anyAttribute> elements allows you to include attributes that are not declared by the schema.

Recursive structures    Excel does not support recursive structures that are more than one level deep.

Abstract elements    Abstract elements are meant to be declared in the schema, but never used as elements. Abstract elements depend on other elements being substituted for the abstract element.

Substitution groups     Substitution groups allow an element to be swapped wherever another element is referenced. An element indicates that it's a member of another element's substitution group through the <substitutionGroup> attribute.

Mixed content Mixed content occurs when an element contains a child element and simple text outside of a child element. One common case is where formatting tags (such as the bold tags) are being used to mark up data within an element.

 
 
Applies to:
Excel 2003