Not able to export to XML from Excel data might require some kind of coding

rhythm_george

New member
Joined
Feb 19, 2015
Messages
2
Reaction score
0
Points
0
I have created an XML file and which I imported into excel using Source option in developers option. But whenever I am trying to export the data I am getting error saying "Can not save or export XML data. The XML maps in this workbook are not exportable". So I required help in this regards and also in <noofmasterinvoices></noofmasterinvoices> and <noofinvoices></noofinvoices> count of master invoice and invoice should appear which I don't know how to do it.

I have copy pasted the XML tagging for your reference and also the excel data.

<!--?xml version="1.0" encoding="UTF-8" standalone="yes"?-->
<company>
<checksum>
<noofmasterinvoices></noofmasterinvoices>
<noofinvoices></noofinvoices>
</checksum>
<masterinvoices>
<masterinvoice>
<masterinoviceno></masterinoviceno>
<masterinvoicedate></masterinvoicedate>
<draweename></draweename>
<draweecountry></draweecountry>
<invoices>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
</invoices>
</masterinvoice>
</masterinvoices>
<masterinvoices>
<masterinvoice>
<masterinoviceno></masterinoviceno>
<masterinvoicedate></masterinvoicedate>
<draweename></draweename>
<draweecountry></draweecountry>
<invoices>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
<invoice>
<invoiceno></invoiceno>
<invoicedate></invoicedate>
<invoiceamt></invoiceamt>
</invoice>
</invoices>
</masterinvoice>
</masterinvoices>
</company>



Excel Data
MASTER INOVICE NOMASTER INVOICE DATEDRAWEE NAMEDRAWEE COUNTRYINVOICE NOINVOICE DATEAMT
142005XYZ COMPANYABC242005100
242005XYZ COMPANYABC142005100
242005XYZ COMPANYABC242005100
242005XYZ COMPANYABC342005100
342005XYZ COMPANYABC142005100
442005XYZ COMPANYABC142005100
442005XYZ COMPANYABC242005100
 
hi,

I find that its not getting exported because of "Denormalized Data" I changed my schema just to match with original.

Any help would be much appreciated.

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<COMPANY>
<checkSum>
<noOfMASTERINVOICES></noOfMASTERINVOICES>
<noOfInvoices></noOfInvoices>
</checkSum>
<MASTERINVOICES>
<MASTERINVOICE>
<MASTERINOVICENO></MASTERINOVICENO>
<MASTERINVOICEDATE></MASTERINVOICEDATE>
<DRAWEENAME></DRAWEENAME>
<DRAWEECOUNTRY></DRAWEECOUNTRY>
<invoices>
<invoice>
<invoiceNo></invoiceNo>
<invoiceDate></invoiceDate>
<INVOICEAMT></INVOICEAMT>
</invoice>
<invoice>
<invoiceNo></invoiceNo>
<invoiceDate></invoiceDate>
<INVOICEAMT></INVOICEAMT>
</invoice>
</invoices>
</MASTERINVOICE>
</MASTERINVOICES>
</COMPANY>
 
Back
Top