Last post Aug 26, 2013 05:50 AM by Happy Chen - MSFT
Aug 23, 2013 04:41 PM|boneill|LINK
Hi, I have a C# app that creates an XmlDocument object by pulling the XML out of an Excel spreadsheet in code. The data is derived from mapping between the XML schema I imported into the Excel file, and mapping it to Excel fields. I am going to receive a
new XML schema that has additional nodes (a work in progress), and when recievced I'll need to use that in my Excel file.
The thing is, I need the mapping from the previous schema to be preserved and applied to the new one (the format is consistant, it's just the new one has more stuff).
Any advice on how to achieve this in either code or Excel directly would be appreciated.
Aug 26, 2013 05:50 AM|Happy Chen - MSFT|LINK
hi boneill ,
From what I understand you want to import the xml data into the Excel file, and mapping it to Excel fields.
I would suggest you to read the reference below for more information:
If you need more assistance ,please let me know.