importing .xml

[Bernie Yaeger]

How can you import a .xml file into Excel 2002 such that it will make use of
the corresponding .xsd? If you simply open the .xml, the data, column
headers, etc are not properly formatted for strings that appear to be
numbers, dates, etc.

Tx for any help.

Bernie Yaeger

 

[Matt Lusher \(MSFT\)]

To make Excel use your XSD, you must first attach it to the spreadsheet as
an XML Map. You can do this through Data > XML > XML Source..., then click
XML Maps... and select the XSD file that corresponds to your XML.

For a good example of how do this, see the Office Online article "Turn
around expense reports in a snap with Excel 2003 and XML", available here:
http://office.microsoft.com/en-us/assistance/HA011109661033.aspx. Good luck!

 

[Matt Lusher \(MSFT\)]

Bernie, you can do this by using an XML Map. XML Maps are Excel's way of
importing XSDs. The idea is that you attach an XSD to your spreadsheet as an
XML Map, and then drag appropriate elements from the map into your
spreadsheet to link your XSD elements to particular cells in the sheet.
There's a good example of this at Office Online:

http://office.microsoft.com/en-us/assistance/HA011109661033.aspx

 

[Bernie Yaeger]

Hi Matt,

Thanks so much for both responses. I will follow your suggestions and I'm
sure it will help me resolve my problems.

Tx again,

Bernie