Export as XML for an Excel Order form document

D

Diane

I have an order management system that allows me to import xml documents.

I have a spreadsheet I am using as an order form for my salespeople.

I was wondering if there is a way to format my "order form spreadsheet" I
get back from my salesperson and save that as an xml document by applying
some type of mapping.

If this is doable, how to I map the document to know what/how to export the
data into logical xml format.

Here is sort of what I am looking for:

Cell A1 is the Customer Name
Cell A2 is the Customer Street Address
Cell A3 is the City
Cell B3 is the State
Cell C3 is the Zip Coce
Cell A5 is Item No. 123
Cell B5 is the Qty Ordered
Cell A6 is Item No. 124
Cell B6 is the Qty Ordered

I would like something like this.

<Order>
<Customer>
<Name>Joe Smith</Name>
<Address>123 Main St</Address>
<City>Atlanta</City>
<State>GA</State>
<Zip>30303</Zip>
</Customer>
<Line>
<Item>123</Item>
<Qty>1</Qty>
</Line>
<Line>
<Item>124</Item>
<Qty>2</Qty>
</Line>
</Order>

Thank you for your time.
Regards,
Diane
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top