{"id":2666,"date":"2016-03-18T11:31:29","date_gmt":"2016-03-18T11:31:29","guid":{"rendered":"http:\/\/www.ericwhite.com\/home2\/bm8qcmjy\/public_html\/blog\/?page_id=2666"},"modified":"2016-03-18T12:11:51","modified_gmt":"2016-03-18T12:11:51","slug":"powertools-for-open-xml-2-0-cmdlets","status":"publish","type":"page","link":"https:\/\/www.ericwhite.com\/blog\/powertools-for-open-xml-2-0-cmdlets\/","title":{"rendered":"PowerTools for Open XML 2.0 Cmdlets"},"content":{"rendered":"<p>This page lists all of the cmdlets in PowerTools for Open XML 2.2. As we add blog posts, articles, and screen-casts about each of the cmdlets, we will link to that content from this page.<\/p>\n<table style=\"border-collapse:collapse;border:none;\" border=\"1\" cellspacing=\"0\" cellpadding=\"5\">\n<tbody>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt; font-weight: bold;\" valign=\"top\">Cmdlet<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt; font-weight: bold;\" valign=\"top\">Description<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlContent<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Injects XML markup into a given part in a WordprocessingML document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlDigitalSignature<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Uses a digital certificate to digitally sign a WordprocessingML document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlDocumentIndex<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Creates an index based on the index references found in the document. This cmdlet and functionality is still under development.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlDocumentTOA<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Creates a Table of Authorities based on the citations (references or authorities) found it in the document. This cmdlet and functionality is still under development.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlDocumentTOC<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Creates a Table of Contents based on the headings found it in the document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlDocumentTOF<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Creates a Table of Figures based on the figures found it in the document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlPicture<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Inserts a picture at a specific location inside an OpenXML document. The picture will be stored inside the document as an embedded resource. Picture location is specified by an XPath expression.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Add-OpenXmlSpreadSheetTable<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Adds a new table definition to a worksheet in a Spreadsheet document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Confirm-OpenXmlValid<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Uses the Open XML SDK 2.0 to validate an Open XML document, and report any errors.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Edit-OpenXmlChange<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Processes documents with text revisions (change tracking elements), by accepting all the text changes performed on the document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Export-OpenXmlSpreadsheet<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Gets the public properties from any objects and generates a spreadsheet with columns showing for each property. Optionally, a chart can be created from a subset of those properties.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Export-OpenXmlToHtml<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Exports Wordprocessing documents to html documents.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Export-OpenXmlWordprocessing<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Create a new Wordprocessing document from text.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlBackground<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Extracts background information from a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlComment<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Extracts all the comments contained in a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlCustomXmlData<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Gets a customXml part from a document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlDigitalSignature<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Gets information about digital signatures present in a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlDocument<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Creates objects for OpenXML documents.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlFooter<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Retrieves footer information from Wordprocessing documents.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlHeader<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Retrieves header information from Wordprocessing documents.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlStyle<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Retrieves style definitions from a Wordprocessing or a Spreadsheet document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlTheme<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Gets the theme content from a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Get-OpenXmlWatermark<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Gets watermark text from a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Lock-OpenXmlDocument<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Locks one or more Wordprocessing documents.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\"><a class=\"ExistingPageLink\" title=\"Click to view the page titled: Merge-OpenXmlDocument\" href=\"https:\/\/www.ericwhite.com\/blog\/merge-openxmldocument\/\">Merge-OpenXmlDocument<\/a><\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Merge multiple source documents into a new document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\"><a class=\"ExistingPageLink\" title=\"Click to view the page titled: Merge-OpenXmlDocumentComment\" href=\"https:\/\/www.ericwhite.com\/blog\/merge-openxmldocumentcomment\/\">Merge-OpenXmlDocumentComment<\/a><\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Merge comments from multiple source documents into a new document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Remove-OpenXmlComment<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Removes comments from Wordprocessing documents.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Remove-OpenXmlDigitalSignature<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Removes the digital signature of a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Remove-OpenXmlMarkup<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Removes a variety of complex markups from a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Remove-OpenXmlPersonalInformation<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Removes personal information from a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Select-OpenXmlString<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Identifies patterns in Wordprocessing documents.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlBackground<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets the background color or image of a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlContentFormat<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets the format of a paragraph or run on a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlContentStyle<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets the style for a paragraph or run on a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlCustomXmlData<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets the contents of a custom XML part in a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlFooter<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets footers in a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlHeader<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets headers on a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlSpreadSheetCellStyle<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Applies a cell style to a cell or cell range in a worksheet.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlSpreadSheetCellValue<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set a value for a cell or a cell range in a worksheet.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlSpreadSheetColumnWidth<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets the width for a column or column range in a worksheet.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\"><a class=\"ExistingPageLink\" title=\"Click to view the page titled: Set-OpenXmlString\" href=\"https:\/\/www.ericwhite.com\/blog\/set-openxmlstring\/\">Set-OpenXmlString<\/a><\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Changes matching strings in a Wordprocessing document to a new value.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlStyle<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets the style library for a Wordprocessing or a Spreadsheet document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlTheme<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets a Wordprocessing document theme.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Set-OpenXmlWatermark<\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Sets a watermark in a Wordprocessing document.<\/td>\n<\/tr>\n<tr>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\"><a class=\"ExistingPageLink\" title=\"Click to view the page titled: Split-OpenXmlDocument\" href=\"https:\/\/www.ericwhite.com\/blog\/split-openxmldocument\/\">Split-OpenXmlDocument<\/a><\/td>\n<td style=\"border: solid windowtext 1.0pt; padding: 0in 5.4pt 0in 5.4pt;\" valign=\"top\">Splits documents at section breaks.<\/td>\n<\/tr>\n<tr>\n<td style=\"width: 120pt; border: none;\"><\/td>\n<td style=\"width: 290pt; border: none;\"><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"<p>This page lists all of the cmdlets in PowerTools for Open XML 2.2. As we add blog posts, articles, and screen-casts about each of the cmdlets, we will link to that content from this page. Cmdlet Description Add-OpenXmlContent Injects XML markup into a given part in a WordprocessingML document. Add-OpenXmlDigitalSignature Uses a digital certificate 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-2666","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2666","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=2666"}],"version-history":[{"count":7,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2666\/revisions"}],"predecessor-version":[{"id":2713,"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/pages\/2666\/revisions\/2713"}],"wp:attachment":[{"href":"https:\/\/www.ericwhite.com\/blog\/wp-json\/wp\/v2\/media?parent=2666"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}