IVL
asked on
Import, modify and export xsd based xml data with excel xml source
We are trying to use Excel to import, modify and export some xml files.
We imported the XSD file Expences3.xsd as an XML Source and mapped the root to cell A1.
We import the xml file Expences3.xml.
The result we get is a de-normalized view of the xml data. Due to the de-normalization, it's no longer possible to export it as xml.
How can we avoid the de-normalization, or what are we doing wrong ?
XSD and XML and Excel Expences3.xlsxfiles in attach
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER
Thanks for you answer Geert,
Excel is for sure not my preferred tool to deal with XML data. Unfortunately many of our users are addicted Excel. That's why I was willing to give it a try.
I'm not fond of using VBA either.
I didn't know a XLSX file is a zip of xml files. It might allow to bypass the export step for the users in several workflows.
I unzipped some files and took a look. It contains several folders with files. I found some things in there, but my understanding of the structures is still far from complete.
I'll use the xlsx in this question to improve my understanding and evaluate if we want to go down this path.
How would we go ahead to