{"id":2667,"date":"2016-03-18T11:31:54","date_gmt":"2016-03-18T11:31:54","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?page_id=2667"},"modified":"2016-03-18T11:31:54","modified_gmt":"2016-03-18T11:31:54","slug":"announcing-the-release-of-powertools-for-open-xml-v4-0-on-github","status":"publish","type":"page","link":"https:\/\/www.ericwhite.com\/blog\/announcing-the-release-of-powertools-for-open-xml-v4-0-on-github\/","title":{"rendered":"Announcing the Release of PowerTools for Open XML v4.0 on GitHub"},"content":{"rendered":"<p>I&#39;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.<\/p>\n<p>This new release has many new features, including:<\/p>\n<ul>\n<li>Renaming the project and the PowerShell module to Open-Xml-PowerTools, to be consistent with the Open-Xml-Sdk.<\/li>\n<li>DocumentAssembler module, which enables populating a template DOCX with data from an XML file.  New video coming shortly.<\/li>\n<li>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.<\/li>\n<li>Many xUnit tests which validate the functionality in Open-Xml-PowerTools.<\/li>\n<li>New PowerShell Cmdlet: Complete-DocxTemplateFromXml, a wrapper over the DocumentAssembler.cs module, which populates a template document from XML.<\/li>\n<li>New PowerShell Cmdlet: Out-Xlsx, which produces an XLSX from a PowerShell object pipeline. Similar in functionality to Out-GridView.<\/li>\n<\/ul>\n<p>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!<\/p>\n<p>The following video walks through the process of cloning the Open-Xml-PowerTools repo:<\/p>\n<p><iframe loading=\"lazy\" title=\"Open Xml PowerTools 4 0 Install\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/60w-yPDSQD0?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#39;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 [&hellip;]<\/p>\n","protected":false},"author":10567,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_s2mail":"","footnotes":""},"class_list":["post-2667","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/users\/10567"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/comments?post=2667"}],"version-history":[{"count":1,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2667\/revisions"}],"predecessor-version":[{"id":2669,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2667\/revisions\/2669"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=2667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}