Export as XML for an Excel Order form document
 

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
<NameJoe Smith</Name
<Address123 Main St</Address
<CityAtlanta</City
<StateGA</State
<Zip30303</Zip
</Customer
<Line
<Item123</Item
<Qty1</Qty
</Line
<Line
<Item124</Item
<Qty2</Qty
</Line
</Order

Thank you for your time.
Regards,
Diane

Export as XML for an Excel Order form document
 

Good morning Diane,

I found these resources and may assist in what you're trying to find
regarding XML and Excel or Access at the following links:

desribes some Excel and Access XML
http://www.meadinkent.co.uk/xl_xml1.htm

and free web tutorials at:
http://www.w3schools.com/


"Diane" wrote:

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
<NameJoe Smith</Name
<Address123 Main St</Address
<CityAtlanta</City
<StateGA</State
<Zip30303</Zip
</Customer
<Line
<Item123</Item
<Qty1</Qty
</Line
<Line
<Item124</Item
<Qty2</Qty
</Line
</Order

Thank you for your time.
Regards,
Diane