[Blog Map] This blog is inactive. New blog: EricWhite.com/blog
Zeyad Rajabi and Frank Rice have put together a cool article, Assembling Documents on SharePoint 2010 Sites by Merging Content from Excel, PowerPoint, and Word, that shows how to build an innovative document generation solution on SharePoint using the Open XML SDK 2.0 where you merge content from Excel and PowerPoint to create an interesting Word document. The article uses the new ‘Document Sets’ feature of SharePoint 2010, and uses content controls in a template Word document to configure the assembly. It contains code to import a chart and table from a spreadsheet to the Word document, and import SmartArt from a presentation to the Word document. The article walks step-by-step through the process of creating a web part that the user uses to initiate document assembly.