I created the following XML format to be able to map to an excel spreadsheet and export to XML when datasets are updated.
When I import the XML into excel, it is recognized as the intended format of the spreadsheet. However, when mapping using the same XML format, I receive the following errors.
Is there any way to map with a schema/xml that does not have the maxoccurs = 1 restriction?
I used the resource below and am not able to replicate:
https://docs.microsoft.com/en-us/previous-versions/office/developer/office-2003/aa203737(v=office.11...
Snippet below:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<part_list>
<part id="Map">
<Option_Code id="FDU1">
<Part_Numbers>
<app>H4B1F1</app>
<boot>H4B100</boot>
<cal>H4B1F1</cal>
<assmb>006351</assmb>
</Part_Numbers>
</Option_Code>
<Option_Code id="FDU2">
<Part_Numbers>
<app>H4B1F2</app>
<boot>H4B100</boot>
<cal>H4B1F2</cal>
<assmb>00488</assmb>
</Part_Numbers>
</Option_Code>
<Option_Code id="FDU3">
<Part_Numbers>
<app>H4B1F3</app>
<boot>H4B100</boot>
<cal>H4B1F3</cal>
<assmb>009545</assmb>
</Part_Numbers>
</Option_Code>
</part>
<part id="Bag">
<Option_Code id="RDU1">
<Part_Numbers>
<app>H4B2R1</app>
<boot>H4B200</boot>
<cal>H4B2R1</cal>
<assmb>004929</assmb>
</Part_Numbers>
</Option_Code>
<Option_Code id="RDU2">
<Part_Numbers>
<app>H4B2R2</app>
<boot>H4B200</boot>
<cal>H4B2R2</cal>
<assmb>006220</assmb>
</Part_Numbers>
</Option_Code>
</part>
<part id="Van">
<Option_Code id="FDU1-RDU1">
<Part_Numbers>
<app>K71000</app>
<boot>K71000</boot>
<cal>K7AEF1R1</cal>
</Part_Numbers>
</Option_Code>
<Option_Code id="FDU1-RDU2">
<Part_Numbers>
<app>K71000</app>
<boot>K71000</boot>
<cal>K7AEF1R2</cal>
</Part_Numbers>
</Option_Code>
<Option_Code id="FDU2-RDU1">
<Part_Numbers>
<app>K71000</app>
<boot>K71000</boot>
<cal>K7ADF2R1</cal>
</Part_Numbers>
</Option_Code>
<Option_Code id="FDU2-RDU2">
<Part_Numbers>
<app>K71000</app>
<boot>K71000</boot>
<cal>K7AEF2R2</cal>
</Part_Numbers>
</Option_Code>
<Option_Code id="FDU3-RDU1">
<Part_Numbers>
<app>K71000</app>
<boot>K71000</boot>
</Part_Numbers>
</Option_Code>
<Option_Code id="FDU3-RDU2">
<Part_Numbers>
<app>K71000</app>
<boot>K71000</boot>
<cal>K7AEF3R2</cal>
</Part_Numbers>
</Option_Code>
</part>
<part id="Hat">
<Option_Code>
<Part_Numbers>
<app>G3D000-</app>
<boot>G3D0000</boot>
<cal>G3D000</cal>
<hardware>G3D000</hardware>
</Part_Numbers>
</Option_Code>
</part>
</part_list>