Creation of XML Files From Excel

A client from Italy has reached us for the following job:

Objective: generate a simple program that generates XML files from combining a constant part with values from Excel. These files are invoices for Amazon.

Process: if you think you have the right experience, please read the ToR carefully. Please contact me with an offer of what fee you would like to generate the xml for me from a similar Excel file.

A) First Part of xml

• The first part of each xml is unchanging:  FatturaElettronicaHeader
• To this I need to append additional xml: Fattura ElettronicaBody
• One xml file is needed for each Amazon Order - each IdDocumento

B) Rest of xml - items ordered (DettaglioLinee)

• An Amazon order might include 1 item (DettaglioLinee) or 2 items or many items.
• If an order has 2 items in it, then the third item (DettaglioLinee, NumeroLinea=3) is always Shipping cost. If the order had 3 items, then this would have NumeroLinea=4, followed by the same Shipping Cost info. If the order had 4 items then the Last NumeroLinea would be 5, etc.
• Then you need to add the rest of the xml.

C) Please try to recreate XML and send it to me to check with you offer of the fee you would need to generate additional XML files for me from the complete Excel.

This is how the Excel file was structured:

And this is print-screen from the Windows Explorer, where you can see files generated: