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
When I open this file in Excel, it creates a row with the element names,
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
the file is not imported in the same way, the title and author entries are
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