| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
strange behaviour in Excel 2003 when importing XML
I have noticed a strange behaviour in the import of XML files.
If I have this XML file: Code:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?
<books
<book
<titleUbik</title
<authorPhilip K. Dick</author
</book
<book
<titleDune</title
<authorFrank Herber</author
</book
</books
title and author, like this. title author Ubik Philip K. Dick Dune Frank Herber When I click on title our author I get the combo box tha allows me to sort the elements. That's exactly what I need. But... If my XML file has only one element like this: Code:
<?xml version="1.0" encoding="UTF-8" standalone="no" ?
<books
<book
<titleUbik</title
<authorPhilip K. Dick</author
</book
</books
missing, the sheet simply looks like this: Ubik Philip K. Dick I don't understand what the problem is. Can anyone suggest how to workaround it so that it shows the title & author row all the time? Thank you very much, Marius Bancila |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
| Help in Excel 2003 | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| sharing/using/saving Excel 2002 files in Excel 2003 | Excel Discussion (Misc queries) | |||
| strange scrolling in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
