Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    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>

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •