This post was started a bit ago but it was never resolved. I am now having this same issue as was wondering if anyone out there can help me come to a solution. I'm using Excel 2010

This came from the post:
When I import XML with multiple rows of data, I get lovely column headers generated for me automatically. When I import XML with only one, single row of data, there are no column headers generated. Since the application I am working with generates the XML dynamically, I would like to know if there is an easy solution for this.

Examples:

This generates column headers when imported into Excel:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<data>
<row>
<name>Chris</name>
<color>green</color>
</row>
<row>
<name>Pat</name>
<color>orange</color>
</row>
</data>

This does NOT generate column headers when imported into Excel:
<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<data>
<row>
<name>Chris</name>
<color>green</color>
</row>
</data>

http://www.excelforum.com/excel-gene...ers-shown.html