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.
None
0 Points
3 Posts
Preserving existing XML schema mapping in Excel, when a new larger XML schema is received?
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.
Thanks,
Barry
ExcelMappingXmlDocument
All-Star
15648 Points
2151 Posts
Re: Preserving existing XML schema mapping in Excel, when a new larger XML schema is received?
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:
http://msdn.microsoft.com/en-us/library/gg469859(v=office.14).aspx
http://office.microsoft.com/en-us/excel-help/map-and-unmap-xml-elements-HP010206397.aspx
If you need more assistance ,please let me know.
ExcelMappingXmlDocument