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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get rid of #agg fields when Importing an XML file into E. 0
XML DTDs Versus XML Schema 0
Can XML Schema Be Refreshed Along with XML Data? 2
XML to Excel conversion issue 1
import XML data...Is there a size limit on the import? 0
Importing XML to Excel - XML Parse Error 0
Import Multiple XML Files into Excel 3
How to open XML data file? 3

Back
Top