http://blogs.msdn.com/pranab/archive/2009/05/14/how-to-publish-ms-excel-cell-values-in-metadata-columns-as-in-quickparts-for-ms-word.aspxWe can achieve this by creating an ItemAdded event receiver. To extract the metadata values from Excel cells, we need OpenXML. In my case, I used a solution called ExcelPackage from CodePlex ( http://www.codeplex.com/ExcelPackage/ ). I modified the sourceen-USCommunityServer 2.1 SP1 (Build: 61025.2)http://blogs.msdn.com/pranab/archive/2009/05/14/how-to-publish-ms-excel-cell-values-in-metadata-columns-as-in-quickparts-for-ms-word.aspx#9616882Thu, 14 May 2009 22:12:55 GMT91d46819-8472-40ad-a661-2c78acb4018c:9616882How to publish MS Excel cell values in Metadata columns as in QuickParts for MS Word | Microsoft Share Point<p>PingBack from <a rel="nofollow" target="_new" href="http://microsoft-sharepoint.simplynetdev.com/how-to-publish-ms-excel-cell-values-in-metadata-columns-as-in-quickparts-for-ms-word/">http://microsoft-sharepoint.simplynetdev.com/how-to-publish-ms-excel-cell-values-in-metadata-columns-as-in-quickparts-for-ms-word/</a></p> http://blogs.msdn.com/pranab/archive/2009/05/14/how-to-publish-ms-excel-cell-values-in-metadata-columns-as-in-quickparts-for-ms-word.aspx#9857212Tue, 04 Aug 2009 19:05:15 GMT91d46819-8472-40ad-a661-2c78acb4018c:9857212Manuel<p>Hi, thanks for this post.</p> <p>I'm attempting something similar, however I need to write data to one of the worksheets.</p> <p>Seems to be OK except the file contents don't update. Have you implemented anything like this?</p> <p>What I'm doing:</p> <p>Add a new file to the library based on a template.-OK</p> <p>Open the file's binary and create a new xlpackage.-OK</p> <p>Get some data and fill one of the worksheets with it.-OK</p> <p>put the updated package stream data back into the SPFile object with the new worksheet data. -NOT OK.</p> <p>New file is in the library but the worksheet has no data.</p> <p>Any ideas?</p>