| Module Name | PSWriteOffice |
|---|---|
| Module Guid | d75a279d-30c2-4c2d-ae0d-12f1f3bf4d39 |
| Download Help Link | https://github.com/EvotecIT/PSWriteOffice |
| Help Version | 0.3.0 |
| Locale | en-US |
PowerShell module to create and read Microsoft Word, Excel, PowerPoint (experimental), Markdown, and CSV documents without Microsoft Office installed. Powered by OfficeIMO.*.
Adds an AutoFilter to the current worksheet.
Adds a chart to the current worksheet using a range or table.
Adds or replaces a comment (note) on a worksheet cell.
Adds a two-color scale conditional format to a range.
Adds a data bar conditional format to a range.
Adds an icon set conditional format to a range.
Adds a conditional formatting rule to the current worksheet.
Adds an image anchored to a worksheet cell.
Adds an image from a URL anchored to a worksheet cell.
Adds a pivot table to a worksheet.
Adds or reuses a worksheet within the current Excel DSL scope.
Adds sparklines to a worksheet.
Writes tabular data to the current worksheet and formats it as an Excel table.
Adds or refreshes a workbook table of contents sheet.
Adds a custom-formula data validation rule to a worksheet range.
Adds a date data validation rule to a worksheet range.
Adds a decimal-number data validation rule to a worksheet range.
Adds a list-based data validation to a worksheet range.
Adds a text-length data validation rule to a worksheet range.
Adds a time data validation rule to a worksheet range.
Adds a whole-number data validation rule to a worksheet range.
Adds a Markdown callout block.
Adds a Markdown code block.
Adds a Markdown definition list.
Adds a collapsible Markdown details block.
Adds YAML front matter to a Markdown document.
Adds a Markdown heading.
Adds a Markdown horizontal rule.
Adds a Markdown image.
Adds a Markdown list.
Adds a Markdown paragraph.
Adds a Markdown block quote.
Adds a Markdown table from objects.
Adds a Markdown table of contents placeholder.
Adds a Markdown task list.
Adds a bulleted list to a PowerPoint slide.
Adds a chart to a PowerPoint slide.
Adds an image to a PowerPoint slide.
Adds a section to a PowerPoint presentation.
Adds a basic shape to a slide.
Adds a new slide to a PowerPoint presentation.
Adds a table to a PowerPoint slide.
Adds a text box to a slide.
Adds a bookmark to the current paragraph.
Adds a chart to a Word document.
Adds a checkbox content control to the current paragraph.
Adds a combo box content control to the current paragraph.
Adds a structured content control to the current paragraph.
Adds a date picker content control to the current paragraph.
Adds a dropdown list content control to the current paragraph.
Adds a field to the current paragraph.
Adds content to a section footer.
Adds content to a section header.
Adds a hyperlink to the current Word paragraph.
Inserts an image into the current paragraph.
Starts a list inside the current section or paragraph anchor.
Adds a single list item.
Adds a PAGE field to the current header/footer.
Adds a paragraph to the current section/header/footer context.
Adds a picture content control to the current paragraph.
Adds a repeating section content control to the current paragraph.
Adds or reuses a section inside the current Word document.
Creates a table from PowerShell objects.
Attaches conditional formatting logic to the current table.
Adds a table of contents to a Word document.
Adds inline text to the current paragraph.
Adds a watermark to the current section or header.
Clears any AutoFilter on the current worksheet.
Closes an Excel workbook and optionally saves it.
Closes a Word document, optionally saving it.
Creates a Word document from HTML.
Creates a Word document from Markdown.
Converts objects or a CSV document into CSV text or a file.
Converts objects into a Markdown table.
Converts Markdown content to HTML.
Converts a Word document to HTML.
Converts a Word document to Markdown.
Copies an existing slide within a PowerPoint presentation.
Finds text matches inside a Word document.
Loads a CSV document from disk or parses CSV text.
Reads CSV rows as PSCustomObjects or dictionaries.
Opens an existing Excel workbook.
Reads worksheet data as dictionaries or PSCustomObjects.
Gets defined names (named ranges) from an Excel workbook.
Gets pivot tables defined in a workbook.
Reads an explicit A1 range from an Excel workbook.
Gets Excel tables defined in a workbook.
Reads the used range from an Excel workbook.
Parses Markdown text or files into a Markdown document model.
Loads an existing PowerPoint presentation.
Lists slide layouts available in a presentation.
Computes reusable layout boxes for a presentation.
Gets layout placeholder metadata for a slide.
Reads speaker notes from a slide or presentation.
Gets placeholder text boxes from a slide.
Gets PowerPoint sections from a presentation.
Reads shape summaries from a slide or presentation.
Enumerates slides or retrieves a specific slide.
Reads high-level slide summaries from a presentation.
Gets theme information for a PowerPoint presentation master.
Opens an existing Word document.
Gets bookmarks from a Word document.
Gets checkbox content controls from a Word document.
Gets combo box content controls from a Word document.
Gets structured content controls from a Word document.
Gets date picker content controls from a Word document.
Gets built-in and custom document properties from a Word document.
Gets dropdown list content controls from a Word document.
Gets fields from a Word document.
Gets hyperlinks from a Word document.
Gets paragraphs from a Word document or section.
Gets picture content controls from a Word document.
Gets repeating section content controls from a Word document.
Gets runs from Word paragraphs.
Gets sections from a Word document.
Gets tables from a Word document or section.
Gets the table of contents from a Word document.
Imports a slide from another PowerPoint presentation.
Automatically fits Excel row heights and/or column widths.
Sorts the used range on the current worksheet.
Executes a simple mail merge against MERGEFIELD values in a Word document.
Creates a new Excel workbook using the DSL.
Creates a Markdown document using a DSL scriptblock.
Creates a PowerPoint presentation using the DSL.
Creates a Word document using the DSL.
Protects the current worksheet.
Protects a Word document with a password.
Removes a comment (note) from a worksheet cell.
Removes a slide by index.
Removes the table of contents from a Word document.
Renames a PowerPoint section.
Saves an Excel workbook without disposing it.
Saves a presentation to disk.
Saves a Word document without disposing it.
Sets a cell value, formula, or number format within the current worksheet.
Configures data labels and optional styling for an Excel chart.
Configures legend visibility and styling for an Excel chart.
Applies a built-in style and color preset to an Excel chart.
Writes values or formatting to a column in the current worksheet.
Sets a formula in a worksheet cell.
Freezes panes on the current worksheet.
Shows or hides worksheet gridlines.
Sets worksheet header and footer text and optional images.
Sets an external hyperlink that displays only the URL host.
Sets a hyperlink on a worksheet cell.
Converts cells in a range into internal workbook links.
Converts cells under a header into internal workbook links.
Sets page margins on a worksheet.
Creates or updates a named range.
Sets the page orientation on a worksheet.
Configures page setup options on a worksheet.
Writes a row of values to the current worksheet.
Shows or hides a worksheet.
Sets an external hyperlink using a smart display strategy.
Converts cells in a range into external URL hyperlinks.
Converts cells under a header into external URL hyperlinks.
Sets the slide background color or image.
Sets layout placeholder bounds for a slide layout.
Sets layout placeholder text margins for a slide layout (points).
Sets layout placeholder text style and bullet/numbering settings.
Sets speaker notes for a PowerPoint slide.
Sets text in a slide placeholder.
Changes the layout used by a slide.
Sets the slide size for a PowerPoint presentation.
Sets the text of the title placeholder on a slide.
Sets the transition used when advancing to a slide.
Sets one or more PowerPoint theme colors.
Sets PowerPoint theme fonts.
Sets the PowerPoint theme name.
Sets the background for a Word document.
Sets a built-in or custom document property on a Word document.
Sets properties on a table of contents in a Word document.
Removes worksheet protection.
Replaces text in a PowerPoint slide or presentation.
Updates fields in a Word document.
Replaces text in a Word document.
Updates the table of contents in a Word document.