D
Diane
I have a spreadsheet with a specific format:
B14: Customer No.
B15: Name
B16: Address
B17: City
B18: State
B19: Zip
A20 (header) B20 (header)
Item No. Qty Ordered
A21 ... A100 B21 ... B100
Column of Item Nos Qty of Each Item No ordered
All fields above B14 should be ignored (they are just visual stuff)
I want to create an XSD to this spreadsheet so I can save the document as
xml I can use and import elsewhere
How can I create the xsd so that I can map the spreadsheet? I guess my
question is - what is my next step so that I can save this as xml in the
proper format. I believe I need to create the xsd so I can map this and then
I can export it as xml.
Am I totally off base - or heading in the right direction?
Any help would be greatly appreciated.
Regards,
Diane
B14: Customer No.
B15: Name
B16: Address
B17: City
B18: State
B19: Zip
A20 (header) B20 (header)
Item No. Qty Ordered
A21 ... A100 B21 ... B100
Column of Item Nos Qty of Each Item No ordered
All fields above B14 should be ignored (they are just visual stuff)
I want to create an XSD to this spreadsheet so I can save the document as
xml I can use and import elsewhere
How can I create the xsd so that I can map the spreadsheet? I guess my
question is - what is my next step so that I can save this as xml in the
proper format. I believe I need to create the xsd so I can map this and then
I can export it as xml.
Am I totally off base - or heading in the right direction?
Any help would be greatly appreciated.
Regards,
Diane