Excel 2007 crashes importing simple xml file

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • James Minns

    #1

    Excel 2007 crashes importing simple xml file

    Hi all,
    I have a problem with Excel 2007: it crashes when importing certain xml
    data, exported from another software
    This is the smallest file which reproduces the problem:

    <?xml version="1.0" standalone="yes "?>
    <ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
    <tblTags>
    <StartDateAndTi me>2000-01-01T00:00:00+01: 00</StartDateAndTim e>
    </tblTags>
    </ds_S3>


    The problem is caused by the StartDateAndTim e value: importing this file
    works:
    <?xml version="1.0" standalone="yes "?>
    <ds_S3 xmlns="http://tempuri.org/ds_S3.xsd">
    <tblTags>
    <StartDateAndTi me>this works...</StartDateAndTim e>
    </tblTags>
    </ds_S3>


    I don't expect Excel to interpret the date - just to show it as a string!
    Anyone confirm or deny this? any solutions?

    Info:
    OS: Vista Business SP1, English
    Excel 2007 SP1, English
    Regional settings: Italian (tried US but no difference)


    Thanks,
    James

Working...