Announcing the Release of PowerTools for Open XML v4.0 on GitHub
I'm very happy to announce the release of PowerTools for Open XML 4.0. With this new release, PowerTools will now live on GitHub, which enables a much more collaborative way of working, as many of you know.
This new release has many new features, 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. New video coming shortly.
- SpreadsheetWriter module, which enables writing simple code to generate an XLSX file. You can optionally use a streaming approach that can write spreadsheets with hundreds of thousands of rows, with good performance.
- Many xUnit tests which validate the functionality in Open-Xml-PowerTools.
- New PowerShell Cmdlet: Complete-DocxTemplateFromXml, a wrapper over the DocumentAssembler.cs module, which populates a template document from XML.
- New PowerShell Cmdlet: Out-Xlsx, which produces an XLSX from a PowerShell object pipeline. Similar in functionality to Out-GridView.
Moving PowerTools to GitHub will enable a much better way of working with you. Please fork the project, submit pull requests, file issues, and collaborate there with me!
The following video walks through the process of cloning the Open-Xml-PowerTools repo: