3

Is there a way to easily export a list to Microsoft Word 2010 from SharePoint 2010 via a button on the page? We'd like to have the data plugged into a Word template so the list values get formatted/placed correctly. We don't mind creating a custom web part if that's what it requires.

Thank you for your guidance.

1 Answer 1

3

It is very easy to create a control or a web part and place it on the page. The control would contain a button with code behind that uses OpenXML to generate the Word document.

I've done similar things and it's very easy. Just create a Word document using Word and format it as you like, then use the Document Reflector from the OpenXML SDK v2+ to generate a C# class that generates a document. Copy that class (and reference the OpenXML assemblies) and modify to suit your needs.

5
  • Thanks, Wictor. You make it sound so easy. As a SharePoint newbie, a detailed article on this would be great :) Also, is it possible to make the button a part of the list actions?
    – Alex C
    Sep 18, 2011 at 8:28
  • 1
    Yea, you could attach it to the ribbon. Sep 18, 2011 at 8:49
  • Thanks, Wictor. Can this 2007 article be used with 2010 to achieve what you talked about for the OpenXML SDK programming? msdn.microsoft.com/en-us/magazine/ee532473.aspx
    – Alex C
    Sep 18, 2011 at 8:53
  • 1
    Yes, it's a starter. Make sure you read what Eric White (ericwhite.com/blog) has written in the past. Sep 18, 2011 at 8:55
  • 1
    In addition to Wictor's answer, I would also recommend to use ClosedXml, a very convenient opensource project to work with OpenXML: closedxml.codeplex.com Sep 18, 2011 at 16:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.