MeroWolfbane
New Member
I do have an XML file which contains several calculated values along with a list of items such as:\[code\]<?xml version="1.0" encoding="utf-8"?><XmlContent> <Elements> <CreationDate>...</CreationDate> <Filename>....</Filename> </Elements> <PersonItems> <PersonItem> <FirstName>...</FirstName> <LastName>...</LastName> <Speed>...</Speed> </PersonItem> <PersonItem> <FirstName>...</FirstName> <LastName>...</LastName> <Speed>...</Speed> </PersonItem> [...] </PersonItems></XmlContent>\[/code\]Now the values should be presented in an Excel sheet using Excel 2007 OpenXmlFormat. The calculated values should be mapped to a specific cell within the worksheet along \[code\]PersonItems\[/code\] should be bound to a table within the same worksheet.Is there a way to embed the XML file into the worksheet package and bind the values to the appropriate fields by using the c# Package API as a \[code\]CustomXmlPart\[/code\]?I found an example on Channel9 where Matthew Scott made something similar with Word 2007 by using the Word Content Control Toolkit. However, this only works with Word.Is there something similar for Excel?Or is there even a better approach for solving this task?