Exporting .xlsx file to .xml file

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:

Image

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.

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

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

@John GRC John Here how looks xml source:

Image

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

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated March 30, 2025 Views 286 Applies to: