Create, Process Open XML Documents Server-side Using PowerShell

You can script documents and spreasheets creation and proecessing on the server.

A new open source project, PowerTools for Open XML, is now up on Codeplex.  Processing Open XML documents server-side using PowerShell is a powerful approach for creating, modifying, and transforming Open XML documents.

PowerTools for Open XML are examples and guidance that show how to do this.  They consist of PowerShell cmdlets, and a number of example scripts that demonstrate the use of the cmdlets.  Examples include automated word processing document and spreadsheet generation, and preparing documents for distribution external to a company, including removing comments, accepting revisions, applying a uniform theme to them, and applying a watermark to them.

For an eight minute screen-cast shows how easy it is to install and use PowerTools for Open XML, see PowerTools for Open XML. For more information, see Processing Open XML Documents Server-Side using PowerShell on Eric White's blog.