xml - excel:无法保存或导出 xml 数据。此工作簿中的 xml 映射不可导出

Question

我想在对从其他 XML 文件导入的数据进行一些修改后将数据导出回 XML 文件(那些第一行变量永远不会改变)。

当我点击 Developer >> export

Excel 显示:

cannot save or export XML data. The XML maps in this workbook are not exportable.

即使我不对数据进行任何修改，也会发生这种情况。

我在 YouTube 上看了几个导出教程，但没有一个能解决我的问题。

Answer 1

通常的原因是 Excel 无法理解非常复杂的 XML。

来自 office.microsoft.com :

An XML mapping cannot be exported if the mapped element’s relationship with other elements cannot be preserved. This relationship may not be preserved for the following reasons:

The schema definition of a mapped element is contained within a sequence with the following attributes:

• The maxoccurs attribute is not equal to 1.
• The sequence has more than one direct child element defined, or has another compositor as a direct child.
• Nonrepeating sibling elements with the same repeating parent element are mapped to different XML tables.
• Multiple repeating elements are mapped to the same XML table, and the repetition is not defined by an ancestor element.
• Child elements from different parents are mapped to the same XML table.

Additionally, the XML mapping cannot be exported if it contains one of the following XML schema constructs:

List of lists

• One list of items contains a second list of items.

Denormalized data

• An XML table contains an element that has been defined in the schema to occur once (the maxoccurs attribute is set to 1). When you add such an element to an XML table, Excel fills the table column with multiple instances of the element.

Choice

• A mapped element is part of a schema construct.