[ARCHIVED] Open-XML-PowerTools

This repository is no longer maintained by Microsoft. It has been archived and can still be forked and cloned for use and continued developement.

If you're looking for a fork of this project that is actively maintained, try the following:

https://github.com/EricWhiteDev/Open-Xml-PowerTools

The Open XML PowerTools provides guidance and example code for programming with Open XML Documents (DOCX, XLSX, and PPTX). It is based on, and extends the functionality in the Open XML SDK (https://github.com/OfficeDev/Open-XML-SDK).

It supports scenarios such as:

• Splitting DOCX/PPTX files into multiple files.
• Combining multiple DOCX/PPTX files into a single file.
• Populating content in template DOCX files with data from XML.
• High-fidelity conversion of DOCX to HTML.
• Managing tracked-revisions, including detecting tracked revisions, and accepting tracked revisions.
• Updating Charts in DOCX/PPTX files, including updating cached data, as well as the embedded XLSX.
• Retrieving metrics from DOCX files, including the hierarchy of styles used, the languages used, and the fonts used.
• Searching and replacing content in DOCX/PPTX using regular expressions.
• Writing XLSX files using far simpler code than directly writing the markup, including a streaming approach that enables writing XLSX files with millions of rows.

Copyright (c) Microsoft Corporation 2012-2015 Licensed under the Microsoft Public License. See License.txt in the project root for license information.

News

We are happy to announce the release of the Open XML PowerTools Version 4.0. There are lots of new features in 4.0, including:

• Renaming the project and the PowerShell module to Open-Xml-PowerTools, to be consistent with the Open-Xml-Sdk.
• DocumentAssembler module, which enables populating a template DOCX with data from an XML file.
• SpreadsheetWriter module, which enables writing far simpler code to generate an XLSX file, and enables a streaming approach.
• Many xUnit tests!!!, which will enable a far nimbler process for accepting contributes to PowerTools via Git pull requests.
• New PowerShell Cmdlet: Complete-DocxTemplateFromXml, which populates a template document from XML
• New PowerShell Cmdlet: Out-Xlsx, which produces an

Build Instructions

To use the PowerShell Cmdlets, you need not install Visual Studio. The following video shows how to install and use PowerTools so that you can use the Cmdlets: