Standards and Tech meeting point

Combining the technologies of PowerShell and Open XML, PowerTools for Open XML is a powerful and convenient way to do server-side document processing. By using PowerTools in you own PS scripts you can manage and generate Word and Excel documents !

PowerTools was already available for several months but Eric White and some talented guys worked hard to bring you PowerTools for Open XML v1.1 with two new cmdlets. Thanks to Bob McClellan and people at Staff Dot Net !

Here’s the newly available cmdlets in PowerTools for Open XML 1.1:

• Merge-OpenXmlDocument : this cmdlet is great, it merge multiple source documents into a new document, remove Paragraphs, move Styles and Fonts to a merged document,
• Select-OpenXmlString : this cmdlet can split a document into multiple documents, extract text of a document and  find documents.

To use PowerTool, you need to install the assembly before :

• 32-bits system :
  • Install : c:\windows\Microsoft.NET\Framework\v2.0.50727\installutil.exe OpenXml.PowerTools.dll
  • Uninstall : c:\windows\Microsoft.NET\Framework\v2.0.50727\installutil.exe -u OpenXml.PowerTools.dll
• 64-bits system :
  • Install : c:\windows\Microsoft.NET\Framework64\v2.0.50727\installutil.exe OpenXml.PowerTools.dll
  • Uninstall : c:\windows\Microsoft.NET\Framework64\v2.0.50727\installutil.exe -u OpenXml.PowerTools.dll

You can find the source code on Codeplex and the binaries here (x86 and x64). I hope that my installers will be ready soon - still need some additional tests - to make them available on this page as well. Stay tuned !