Exporting .xlsx file to .xml file

Question

Hi,

I have a problem. I can't export .xlsx file to .xml file. After mapping elements and wanted to verify it I have got this message:

That is a reason why I can't export .xlsx file to .xml file. But I don't get how to resolve it, to fix that error.

Answer 1

Hi. Thank you for your question and reaching out. My name is John and I’d be more than happy to help you with your query.

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 for which the following are true: -The maxoccurs attribute is not equal to 1. -The sequence has more than one direct child element defined, or it 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 contents of an XML mapping cannot be exported if the contents contain 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, the table column is filled with multiple instances of the element.

-Choice This is a mapped element that is part of a <choice> schema construct.

For more information, see https://support.microsoft.com/en-us/office/0b21f51b-56d6-48f0-83d9-a89637cd4360

Best regards, John

Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

Answer 2

@John GRC John Here how looks xml source:

Anything bad with this or with excel file itself? I can't identify the real reason for this.