Microsoft KB Archive/840475

= How formatting is applied to imported XML data in Excel 2003 =

Article ID: 840475

Article Last Modified on 6/2/2004

-

APPLIES TO


 * Microsoft Office Excel 2003

-





INTRODUCTION
This article describes how formatting is applied to imported XML data in Microsoft Office Excel 2003.



MORE INFORMATION
When you import XML data into cells that have formatting, Excel 2003 compares the cell formatting to the XML Schema Definition (XSD) data type. If the formatting is compatible, the data is imported and the cell formatting is not changed. For example, the existing cell format is a number that has two decimal places, and you import an element that has a data type of long. If the data type is not compatible, you receive a warning dialog box that prompts you to select one of the following actions:
 * Use existing formatting - ignore the XSD data type.
 * Match element data type - change the cell formatting to the appropriate type.
 * Cancel - do not import the XML data.

When you import XML data into cells that do not have formatting or when you choose to change the formatting to match the data type, Excel 2003 applies a display format that is based on the XML XSD data type. For example, when you import a DateTime date type, the cell format changes to a date format. Some data is imported, and then a general format is applied to the cells.

The following table lists supported and unsupported XSD data types. Data with an XSD format listed in the Unsupported Formats column is imported as text values.

Keywords: kbinfo KB840475

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.