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
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 |