Importing XML

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Hi,

I am importing a well-formed XML file, but Excel adds an
extra ".../#agg" column for every numeric column in the
data. I understand the purpose of Aggregate fields, but
is there any way to prevent these extra columns on simple
XML structures.

Also, my XML file does not contain any schema definition
or style sheets. Thanks for any help.

Todd
 
This applies if you are using excel 2003

When you import an XML file exile automatically uses the import as list and that is why you are getting the extra columns (excel denormalizes the xml elements when there is ambiguity)

You should open the file via File->Open or you should use the XML task pane and click XML Maps then Add and browse to your XML file --- this way you will see a map of your XML elements in the task pane and you will be able to drag your elements onto the grid with finer control

-emilio
 
Back
Top