ottomatt - Open-XML-PowerTools 1.0.1
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 of the 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/CSS.
High-fidelity conversion of HTML/CSS to DOCX.
Searching and replacing content in DOCX/PPTX using regular expressions.
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.
Comparing two DOCX files, producing a DOCX with revision tracking markup, and enabling retrieving a list of revisions.
Retrieving metrics from DOCX files, including the hierarchy of styles used, the languages used, and the fonts used.
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.
Extracting data (along with formatting) from spreadsheets.
Copyright (c) Microsoft Corporation 2012-2016 Portions Copyright (c) Eric White 2016 Licensed under the Microsoft Public License. See License.txt in the project root for license information.
PM> Install-Package Open-XML-PowerTools -Version 1.0.1 -Source https://www.myget.org/F/ottomatt/api/v3/index.json
> nuget.exe install Open-XML-PowerTools -Version 1.0.1 -Source https://www.myget.org/F/ottomatt/api/v3/index.json
> dotnet add package Open-XML-PowerTools --version 1.0.1 --source https://www.myget.org/F/ottomatt/api/v3/index.json
source https://www.myget.org/F/ottomatt/api/v3/index.json
nuget Open-XML-PowerTools ~> 1.0.1
Copy to clipboard
> choco install Open-XML-PowerTools --version 1.0.1 --source https://www.myget.org/F/ottomatt/api/v2
Import-Module PowerShellGet
Register-PSRepository -Name "ottomatt" -SourceLocation "https://www.myget.org/F/ottomatt/api/v2"
Install-Module -Name "Open-XML-PowerTools" -RequiredVersion "1.0.1" -Repository "ottomatt"
Copy to clipboard
[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:
Version 4.3 : June 13, 2016
New WmlComparer module
Version 4.2 : December 11, 2015
New SmlDataRetriever module
New SmlCellFormatter module
Version 4.1.3 : November 2, 2015
DocumentAssembler: Fix bug associated with duplicate bookmarks.
DocumentAssembler: Enable processing of content controls / metadata in footer rows.
DocumentAssembler: Avoid processing content controls used for purposes other than the DocumentAssembler template, including page numbers in footers, etc.
Version 4.1.2 : October 31, 2015
HtmlToWmlConverter: Handle unknown elements by recursively processing descendants
Version 4.1.1 : October 21, 2015
Fix to AddTypes.ps1 to compile WmlToHtmlConverter.cs instead of HtmlConverter.cs
Fix to MettricsGetter.ps1 to correctly report whether a document contains tracked revisions
Added some unit tests for PresentationBuilder
Version 4.1.0 : September 27, 2015
New HtmlToWmlConverter module
HtmlConverter generates non breaking spaces as #00a0 unicode charater, not entity.
Version 4.0.0 : August 6, 2015
New DocumentAssember module
New SpreadsheetWriter module
New Cmdlet: Complete-DocxTemplateFromXml
Fix DocumentBuilder: deal with headers / footers more rationally
Enhance DocumentBuilder: add option to discard headers / footers from section (but keep layout of section)
Fix RevisionAccepter: deal with w:moveTo immediately before a table
New test document library in the TestFiles directory
XUnit tests
Cleaned up build system
Build using the open source Open-Xml-SDK and the new System.IO.Packaging by default
Back port to .NET 3.5
Rename the PowerShell module to Open-Xml-PowerTools
Version 3.1.11 : June 30, 2015
Updated projects and solutions to build with the open source Open XML SDK and new System.IO.Packaging
Version 3.1.10 : June 14, 2015
Changed Out-Xlsx Cmdlet to C# implementation
Fix Add-DocxText
Version 3.1.09 : April 20, 2015
Fix OpenXmlRegex: PowerPoint 2007 and xml:space issues, causing 2007 to not open PPTX's
Version 3.1.08 : March 13, 2015
Added Out-Xlsx Cmdlet
Version 3.1.07 : February 9, 2015
Added Merge-Pptx Cmdlet
Added New-Pptx Cmdlet
Added New-PmlDocument
Fixed help for Merge-Docx
Don't throw duplicate attribute exception when running FormattingAssembler.AssembleFormatting twice on same document.
Version 3.1.06 : February 7, 2015
Added Expand-DocxFormatting Cmdlet
Cmdlets do not keep a handle to the current directory, preventing deletion of the directory.
Added additional tests to Test-OxPtCmdlets
Version 3.1.05 : January 29, 2015
Added GetListItemText_zh_CN.cs
Fixed GetListItemText_fr_FR.cs
Partially fixed GetListItemText_ru_RU.cs
Fixed GetListItemText_Default.cs
Added better support in ListItemRetriever.cs
Added FileUtils class in PtUtil.cs
Version 3.1.04 : December 17, 2014
Added Get-DocxMetrics Cmdlet
Added New-WmlDocument Cmdlet
Added MetricsGetter.cs module
Added MettricsGetter01.cs module, along with sample documents
Reworked Add-DocxText, new style of using it with New-WmlDocument
Version 3.1.03 : December 9, 2014
Added ChartUpdater.cs module
Added ChartUpdater01.cs module, along with sample documents
Added Test-OxPtCmdlets Cmdlet
Version 3.1.02 : December 1, 2014
Added Add-DocxText Cmdlet
Version 3.1.01 : November 23, 2014
Added Convert-DocxToHtml Cmdlet
Added Chinese and Hebrew sample documents
Cmdlets in this release Clear-DocxTrackedRevision Convert-DocxToHtml ConvertFrom-Base64 ConvertFrom-FlatOpc ConvertTo-Base64 ConvertTo-FlatOpc Get-OpenXmlValidationErrors Merge-Docx New-Docx Test-OpenXmlValid
Version 3.1.00 : November 13, 2014
Changed installation process - no longer requires compilation using Visual Studio
Added ConvertTo-FlatOpc Cmdlet
Added ConvertFrom-FlatOpc Cmdlet
Changed parameters for Test-OpenXmlValid, Get-OpenXmlValidationErrors
Removed the unnecessary 1/2 second sleep when doing Word automation in the New-Docx Cmdlet
Version 3.0.00 : October 29, 2014
New release of cmdlets that are written as 'Advanced Functions' instead of in C#.
OwnersLaurent Dardenne |
AuthorsEric White |
Project URLhttps://github.com/OfficeDev/Open-Xml-PowerTools |
LicenseUnknown |
TagsXML Office Powertools OpenXML |
Info84 total downloads |
69 downloads for version 1.0.1 |
Download (5.4 MB) |
Found on the current feed only |
Package history
Version | Size | Last updated | Downloads | Mirrored? | |||
---|---|---|---|---|---|---|---|
1.0.1 | 5.4 MB | Sun, 23 Oct 2016 14:35:57 GMT | 69 | ||||
1.0.0 | 5.39 MB | Sat, 22 Oct 2016 17:17:55 GMT | 15 |