PDA

View Full Version : Not able to export to XML from Excel data might require some kind of coding



rhythm_george
2015-02-19, 11:22 AM
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 NO
MASTER INVOICE DATE
DRAWEE NAME
DRAWEE COUNTRY
INVOICE NO
INVOICE DATE
AMT


1
42005
XYZ COMPANY
ABC
2
42005
100


2
42005
XYZ COMPANY
ABC
1
42005
100


2
42005
XYZ COMPANY
ABC
2
42005
100


2
42005
XYZ COMPANY
ABC
3
42005
100


3
42005
XYZ COMPANY
ABC
1
42005
100


4
42005
XYZ COMPANY
ABC
1
42005
100


4
42005
XYZ COMPANY
ABC
2
42005
100

rhythm_george
2015-02-19, 01:52 PM
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>