CODEWITHSUNDEEP
xmlexcel-2010
merk
merk

Reputation: 1741

excel 2010 import xml with nested elements creating duplicate records

I have an xml file which imports fine except for one problem. Each record in the xml file has an element which can contain multiple elements.

When i import this, excel creates a new record for every . So if i have a record that has 5 images, I'll have 5 rows in the excel table which are all duplicate except for the image column.

I'd like it if excel just added enough columns so that all the images associated with each record were on a single row and I didn't have duplicate records.

Anyone know if this can be done with excel 2010? I can upgrade to excel 2013 if it would make a difference.

Upvotes: 1

Views: 2447

Answers (1)

raybiss
raybiss

Reputation: 401

I don't think it would make any difference.

Excel not being hierarchical (like XML), will interprets your 5 images as 5 different records (with the same ancestors data).

You might be able to do what you want with some XML mapping but I never tried it myself.

You could also write a custom vba function to import the xml as you like.

Upvotes: 1

Related Questions