Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,917 questions
I wan to export XML from Excel where The maxoccurs attribute is not equal to 1.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(227.2, 55.00000000000001%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESI%3C/text%3E%3C/svg%3E)
Sabeen Iqbal
0
Reputation points
I want to export XML and one of the tag/element has multiple value in one record. Excel gives me error like "can not save or export XML data. the XML maps in this workbook are not exportable."
and I similarly when I import such file into excel one record is repeated multiple time like in the screen shot.
I have a XSD file, may be it is of some help here.
Below is the element/tag that can have multiple values
<ModuleInstance>
<MODINSTID>3</MODINSTID>
<MODID>345</MODID>
<MODINSTSTARTDATE>2024-01-01</MODINSTSTARTDATE> </ModuleInstance>
Is there a way around it??
Office
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,831 questions
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(300.8, 81%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETJ%3C/text%3E%3C/svg%3E)
Tom Jebo 2,081 Reputation points Microsoft Employee2024-02-15T07:50:55.6866667+00:00 Hi @Sabeen,
Can you clarify how you are trying to export the XML data and what kind of XML data this is? It looks like perhaps this is related to exporting a VBA module but I'm not sure what you are doing.
Best regards,
Tom Jebo
Microsoft Open Specifications Support -
Sabeen Iqbal 0 Reputation points
2024-02-15T10:09:47.22+00:00 Actually I am suppose to do data entry of students record and give the file in XML format. I have made a sample xml file. then use this sample file as XML map. the above tag/element "<ModuleInstance>" is the tag that has multiple value for one student.
below I am pasting the sample xml file I mentioned above.<datafutures><Student><SID>123456</SID><BIRTHDTE>1940-03-29</BIRTHDTE><ETHNIC>120</ETHNIC><FNAMES>Stu1 first name</FNAMES><GENDERID>01</GENDERID><NATION>IT</NATION><OWNSTU>123456</OWNSTU><RELIGION>22</RELIGION><SEXID>11</SEXID><SEXORT>12</SEXORT><SSN>DDDD12345678T</SSN><SURNAME>Stu1 last name</SURNAME><TTACCOM>04</TTACCOM><TTPCODE>N18 1HP</TTPCODE><Disability><DISABILITY>95</DISABILITY></Disability><Engagement><NUMHUS>1</NUMHUS><ENGEXPECTEDENDDATE>2023-06-23</ENGEXPECTEDENDDATE><ENGSTARTDATE>2022-09-26</ENGSTARTDATE><FEEELIG>01</FEEELIG><EntryProfile><HIGHESTQOE>I0000</HIGHESTQOE><PERMADDCOUNTRY>XF</PERMADDCOUNTRY><PERMADDPOSTCODE>N18 1HP</PERMADDPOSTCODE><PREVIOUSPROVIDER>12345678</PREVIOUSPROVIDER><EntryQualificationAward><ENTRYQUALAWARDID>1</ENTRYQUALAWARDID><ENTRYQUALAWARDRESULT>0001</ENTRYQUALAWARDRESULT><QUALTYPEID>19</QUALTYPEID><EntryQualificationSubject><SUBJECTID>03P</SUBJECTID></EntryQualificationSubject></EntryQualificationAward></EntryProfile><Leaver><ENGENDDATE>2022-10-28</ENGENDDATE><RSNENGEND>11</RSNENGEND></Leaver><QualificationAwarded><QUALAWARDID>1</QUALAWARDID><QUALAWARDRESULT>0001</QUALAWARDRESULT><QUALID>asd</QUALID></QualificationAwarded><StudentAccreditationAim><STUACCID>05804</STUACCID></StudentAccreditationAim><StudentCourseSession><SCSESSIONID>2323234</SCSESSIONID><COURSEID>DET</COURSEID><INTERCALATION>01</INTERCALATION><INVOICEFEEAMOUNT>6000</INVOICEFEEAMOUNT><INVOICEHESAID>5053</INVOICEHESAID><RSNSCSEND>01</RSNSCSEND><SCSENDDATE>2023-10-03</SCSENDDATE><SCSFEEAMOUNT>6000</SCSFEEAMOUNT><SCSMODE>01</SCSMODE><SCSSTARTDATE>2022-09-26</SCSSTARTDATE><SESSIONYEARID>2323234</SESSIONYEARID><YEARPRG>1</YEARPRG><ModuleInstance><MODINSTID>3</MODINSTID><MODID>345</MODID><MODINSTSTARTDATE>2024-01-01</MODINSTSTARTDATE></ModuleInstance><ModuleInstance1><MODINSTID>3</MODINSTID><MODID>345</MODID><MODINSTSTARTDATE>2024-01-01</MODINSTSTARTDATE></ModuleInstance1><ReferencePeriodStudentLoad><REFPERIOD>01</REFPERIOD><YEAR>2022</YEAR><RPSTULOAD>100</RPSTULOAD></ReferencePeriodStudentLoad><SessionStatus><STATUSVALIDFROM>2023-09-28</STATUSVALIDFROM><STATUSCHANGEDTO>02</STATUSCHANGEDTO></SessionStatus><StudyLocation><STUDYLOCID>A</STUDYLOCID><STUDYPROPORTION>100</STUDYPROPORTION><VENUEID>A</VENUEID></StudyLocation></StudentCourseSession></Engagement></Student></datafutures>Here first record has multiple values/instances of "<ModuleInstance>", while 2nd record has only one value while remining do not have instance of the "<ModuleInstance>" When I remove the multiple instance of the "<ModuleInstance>" I can export the xml from Excel and also import the XML in excel with out any issues.Hope I have cleared your question, and thanks for your time to look into it.
-
-
Sabeen Iqbal 0 Reputation points
2024-02-16T11:08:52.3866667+00:00 Hi Tom Is it possible I can contact Excel/Office team directly because I need to find a solution of this, I have been searching internet for 4 5 days but can not find any thing so far. Thanks in advance
-
Sabeen Iqbal 0 Reputation points
2024-02-16T11:51:40.47+00:00 Hi @Tom Jebo Is it possible that I can contact Excel/Office team myself, because I need to solve find a solution to this problem and searching on internet is leading me to dead ends.
thanks in advance
Sign in to comment
Sign in to answer