Blogger :
MSDN Blogs
All posts :
All posts by MSDN Blogs
Category :
Orchestration / Workflow
Blogged date : 2008 Jul 23
This post presents a custom application page in SharePoint that uses Open XML, the Open XML SDK and LINQ to XML to accept revisions, remove comments, and remove personal information from an Open XML word processing document.
The following 45 second screen-cast demonstrates the code presented in this post.
Video: Using Open XML with SharePoint
An approach that has interesting possibilities would be to create SharePoint workflows that query and modify Open XML documents. For example, you could write some code that would ensure that no documents in a SharePoint document library have comments, revisions, or personal information. I’ll present this code in the future.
To make my development as easy as possible, I created a class, OpenXmlInfo, which has methods to query and modify the Open XML document. I developed the class using a console application. Then, when the class was coded and debugged, it was a simple matter to use it in the SharePoint custom application page. The class contains six static methods; three to query a document, and three to modify a document. Here are the signatures of the methods:
public static bool InspectForComments(WordprocessingDocument document)
public static bool InspectForRevisions(WordprocessingDocument doc)
public static bool InspectForPersonalInfo(WordprocessingDocument document)
public static void RemoveComments(WordprocessingDocument document)
public static void AcceptRevisions(WordprocessingDocument doc)
public static void RemovePersonalInfo(WordprocessingDocument document)
These methods are based on code that is presented in the following blog posts:
The custom application page (OpenXmlInspector.aspx) contains a few C# methods. They are pretty straightforward.
To open the document using the Open XML SDK, the code does the following:
-
Once the code has the document in an SPFile object, it uses the OpenBinary() method to get a byte array that contains the document. However, the Open XML SDK needs a stream to instantiate the document, so the code creates a MemoryStream from the byte array.
-
The code then creates the WordprocessingDocument from the stream.
The feature adds a menu item (Inspect Open XML Document) to the ECB menu. (The ECB menu is the drop down menu that you get for each document in a document library.)
To use this code, you will need to install the Open XML SDK.
For a good screen-cast on creating a feature in SharePoint, see Ted Pattison’s web cast. In addition, there are some great resources at http://www.microsoft.com/click/SharePointDeveloper/.
Note that this code is just a demonstration of using the Open XML SDK and LINQ to XML to query and modify documents; you would want to make modifications to this code before deploying it in a production environment. For instance, the code does not validate that the document is an Open XML document before querying it. I’m presenting it as an example of the type of development that you can do using these technologies.
Code is attached.
Contents
ReBlogger Contents
Email TopXML