Importing XML, one row of data no column headers shown

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

Could you upload a sample file perhaps? If you do so be aware of the fact that the forum "Attachment Manager" will not accept a file with an xml exstencion you need to rename it to xls in order to upload it.

Alf

I've attached an example file which only contains 1 row. But when I imported to excel 2010 the headers are missing.

Any help on this?

Sorry I can’t find any solution to you problem. I’ve had an OP who needed a macro to import xml files and I’ve been studying his file (imports to columns) to see if I could find how it differed from your file but could not see anything that explains you problem.

If you like to have a go at it the thread is here

http://www.excelforum.com/excel-prog...ml#post3575403

and you will find his file in post #10. The file has an xls extension so you need to rename it to xml.

Alf

Sound good. I'll check it out. Thanks