How to remove the extra #agg column in excel ?

[royboy75]

Hello,

I am importing an xml file into excel.
The problem I have is that when a column contains numbers excel creates an extra "Fill down column with an #agg suffix. In this column, the value of the first node in the level above it is listed once and then omitted for remaining rows.
An example can be seen here:

http://support.microsoft.com/kb/288215

I would like to remove this extra column because it disturbs me for other processings I am doing next.
How can tell excel to omit this column? Is there an xml property that deals with it?

 

[harebrain]

That's a function of Excel's XML "flattener," and really doesn't have anything to do with XML. It shows that your XML contains parent/child relationships. If you're importing as an XML list, you should be able to delete the column from the list toolbar.

 

[royboy75]

Is it possible to modify the flattener properties?

 

[harebrain]

Probably not, but you can bypass it altogether by supplying an XSLT that flattens your data the way you want. See

http://msdn2.microsoft.com/en-us/library/aa140055(office.10).aspx