Word Automation Services in Sharepoint 2010 to replace content in a Word Document

Question

I have a scenario in which I have to replace few contents in a word document based on the library / list input form of sharepoint 2010.

Example :

I have 2 Placeholders : [Title] and [SubTitle]

Now, if the end user, using sharepoint's default new form enters the value of Title and SubTitle as "New" and "NewTest" respectively then this should get replaced in the word document on the submission of the new form.

how to accomplish this using server side code?

Thank you

Answer 1

You can achieve this without writing single line of code if you want to do in document library(Not in list).

You can create one word template for document library and add field place holder to that file. SharePoint will update its value automatically once you update it in new/edit form.

Visit this to know how to configure it.

Hope it will help :)

Answer 2

This is not a SharePoint specific question and it might get moved to another board. Follow the following steps and make changes where needed.

1. Install Open XML SDK 2.5 on server. More info: here and here
2. Add required references. More on this: here

3. Open the document from the library:

   byte[] byteArray = File.ReadAllBytes("PATH_TO_DOCUMENT_IN_LIBRARY"); MemoryStream mem = new MemoryStream(); mem.Write(byteArray, 0, (int)byteArray.Length); WordprocessingDocument _wordDoc = WordprocessingDocument.Open(mem, true); string _w = "http://schemas.openxmlformats.org/wordprocessingml/2006/main"; MainDocumentPart part = _wordDoc.MainDocumentPart; NameTable nt = new NameTable(); XmlNamespaceManager _nsManager = new XmlNamespaceManager(nt); XmlNamespaceManager _nsManager.AddNamespace("w", _w); XmlDocument _xmlDoc = new XmlDocument(nt); XmlDocument _xmlDoc.Load(part.GetStream());

4. Insert text into a bookmark:

   public void InsertTextIntoBookmark(string bookmarkName, string text) { if ((text != String.Empty) && (text != null)) { //find it XmlElement bookmarkStartNode = (XmlElement)_xmlDoc. DocumentElement.SelectSingleNode("//w:bookmarkStart[@w:name='" + bookmarkName + "']", this._nsManager); XmlNodeList followingNodesList = bookmarkStartNode. SelectNodes(".//following::w:t | .//following::w:bookmarkEnd[@w:name='" + bookmarkName + "']", this._nsManager); foreach (XmlElement el in followingNodesList) { var res = from bm in this._wordDoc.MainDocumentPart.Document.Body.Descendants<DocumentFormat.OpenXml.Wordprocessing.BookmarkStart>() where bm.Name == bookmarkName select bm; var bk = res.SingleOrDefault(); if (bk != null) { DocumentFormat.OpenXml.Wordprocessing.Run bookmarkText = bk.NextSibling<DocumentFormat.OpenXml.Wordprocessing.Run>(); if (bookmarkText != null) { bookmarkText.GetFirstChild<DocumentFormat.OpenXml.Wordprocessing.Text>().Text = text; el.InnerText = text; } else { var parent = bk.Parent; // bookmark's parent element DocumentFormat.OpenXml.Wordprocessing.Run run = new DocumentFormat.OpenXml.Wordprocessing.Run( new DocumentFormat.OpenXml.Wordprocessing.RunProperties()); DocumentFormat.OpenXml.Wordprocessing.Text txt = new DocumentFormat.OpenXml.Wordprocessing.Text(text); run.Append(txt); // insert after bookmark parent parent.Append(run); } bk.Remove(); } } //flush to doc _xmlDoc.Save(_wordDoc.MainDocumentPart.GetStream(FileMode.Create)); } }

Hope this helps.

P.S. Someone please help me to format the code :)