Why PSWriteOffice?
PSWriteOffice brings the OfficeIMO document stack to PowerShell. The command surface shown here is generated from the current module manifest used for this release. Create, inspect, update, review, convert, secure, and deliver documents from scripts and automation jobs without maintaining a separate document engine.
Features
- Manifest-derived command catalog — cmdlets, aliases, and families are counted from the current module manifest
- DSL aliases — intuitive shorthand like
WordParagraph,ExcelSheet, andPptSlidefor concise scripts - Broad document platform — Word, Excel, PowerPoint, PDF, Reader, Visio, Markdown, CSV, RTF, OpenDocument, email, AsciiDoc, LaTeX, and HTML asset workflows
- Cross-platform — PowerShell 7.4 or newer runs on Windows, Linux, and macOS
- Windows PowerShell — supports Windows PowerShell 5.1 on Windows; modern batch PDF export requires PowerShell 7.4 or newer
Command families
The current module exports 482 cmdlets and 176 aliases across 22 documentation families. Cross-format commands have one documentation owner, so the family totals match the manifest.
| Family | Cmdlets | Typical work |
|---|---|---|
| Project | 20 | Create schedules, inspect tasks and resources, exchange mapped tables, and save qualified native or XML projects. |
| Access | 9 | Read native database schemas and rows, and create qualified table databases without ACE or COM. |
| EPUB | 8 | Read, create, and save EPUB publications from chapters, resources, and metadata. |
| Document operations and capabilities | 11 | Inspect, compare, validate, repair, protect, combine, split, and convert documents through the shared native operations. |
| Word | 81 | Create, inspect, update, review, merge, protect, and convert DOC and DOCX documents. |
| Excel | 103 | Build, read, convert, validate, repair, compare, and publish XLS and XLSX workbook workflows. |
| PowerPoint | 53 | Compose, inspect, update, import, theme, and render repeatable presentation decks. |
| 77 | Author, inspect, transform, sign, annotate, extract, preflight, and combine PDF files. | |
| Reader, extraction, and OCR | 11 | Detect formats and extract normalized documents, chunks, tables, visuals, assets, OCR text, and ingest results. |
| Archive migration and evidence | 5 | Inspect package safety and provenance, convert iWork and offline OneNote content, and retain fidelity evidence. |
| Google Workspace | 1 | Create an authenticated session for native Google Docs, Sheets, and Slides operations. |
| Confluence Cloud | 7 | Plan and publish pages, preserve managed sections, and transfer attachments through OfficeIMO.Confluence. |
| Visio | 20 | Create, inspect, arrange, and export VSDX diagrams with built-in and imported stencils. |
| Markdown | 33 | Compose typed Markdown, parse documents, and convert between Markdown and HTML or Word. |
| RTF | 8 | Create, open, edit, inspect, and bridge Rich Text Format documents. |
| CSV | 3 | Create, import, inspect, and export delimited data with typed options. |
| OpenDocument | 11 | Compose, read, convert, and save ODT, ODS, and ODP workflows. |
| 9 | Read and write messages and mailbox artifacts through the managed OfficeIMO.Email engine. | |
| AsciiDoc | 3 | Read, create, update, and save bounded AsciiDoc workflows. |
| LaTeX | 3 | Read, create, update, and save bounded LaTeX interoperability workflows. |
| HTML assets | 5 | Export images and review surfaces used by document-to-HTML workflows. |
| Cross-format visuals | 1 | Convert reusable visual artifacts for Word, Excel, PowerPoint, and PDF placement. |
Browse the generated family guide or search the PowerShell API reference for parameter-level detail.
Start from a real workflow
| Job | Working path |
|---|---|
| Review patch compliance and maintenance actions | Patch report walkthrough and native downloads |
| Reconcile budget, actual spending and forecast | Budget review, workbook and CSV input |
| Review delivery milestones and overdue actions | Project review, milestone register and CSV input |
| Export SQL data to Excel and verify the round trip | DbaClientX database reporting guide and the runnable Excel example |
| Move database data through CSV | Runnable CSV round-trip example |
| Create an operational Excel dashboard | Excel showcase example |
| Review quarterly support demand in PowerPoint | CSV-driven service brief with location totals, ticket comparisons and dated actions. |
| Browse copyable PowerShell patterns | PSWriteOffice recipe gallery |
| Compare Excel and CSV performance | PSWriteOffice benchmark guide |
| Evaluate mixed search, authenticated PDF, or Confluence publishing | PSWriteOffice command families |
Quick start
# Install the module
Install-Module PSWriteOffice -Force
# Create a Word document
New-OfficeWord -Path ".\Report.docx" {
Add-OfficeWordSection {
Add-OfficeWordParagraph -Style Heading1 -Text "Monthly Report"
Add-OfficeWordParagraph -Text "Generated on $(Get-Date -Format 'MMMM yyyy')"
$data = @(
[pscustomobject]@{ Region = "North"; Revenue = 42000; Target = 40000 }
[pscustomobject]@{ Region = "South"; Revenue = 38000; Target = 35000 }
[pscustomobject]@{ Region = "East"; Revenue = 29000; Target = 30000 }
[pscustomobject]@{ Region = "West"; Revenue = 51000; Target = 45000 }
)
Add-OfficeWordTable -InputObject $data -Style GridTable4Accent1
Add-OfficeWordParagraph {
Add-OfficeWordText -Text "All regions met or exceeded targets except East."
}
}
}
# Create an Excel workbook
New-OfficeExcel -Path ".\Metrics.xlsx" {
Add-OfficeExcelSheet -Name "Summary" {
Set-OfficeExcelCell -Address "A1" -Value "Metric"
Set-OfficeExcelCell -Address "B1" -Value "Value"
Set-OfficeExcelCell -Address "C1" -Value "Status"
Set-OfficeExcelCell -Address "A2" -Value "Uptime"
Set-OfficeExcelCell -Address "B2" -Value "99.97%"
Set-OfficeExcelCell -Address "C2" -Value "OK"
Set-OfficeExcelCell -Address "A3" -Value "Response Time"
Set-OfficeExcelCell -Address "B3" -Value "42ms"
Set-OfficeExcelCell -Address "C3" -Value "OK"
}
Add-OfficeExcelSheet -Name "Details" {
Set-OfficeExcelCell -Address "A1" -Value "Timestamp"
Set-OfficeExcelCell -Address "B1" -Value "Endpoint"
Set-OfficeExcelCell -Address "C1" -Value "Latency"
$rowIndex = 2
1..10 | ForEach-Object {
Set-OfficeExcelCell -Row $rowIndex -Column 1 -Value ((Get-Date).AddMinutes(-$_))
Set-OfficeExcelCell -Row $rowIndex -Column 2 -Value "/api/data"
Set-OfficeExcelCell -Row $rowIndex -Column 3 -Value (Get-Random -Minimum 20 -Maximum 80)
$rowIndex++
}
}
}
# Create a PowerPoint presentation
$ppt = New-OfficePowerPoint -FilePath ".\Status.pptx"
$slide = Add-OfficePowerPointSlide -Presentation $ppt
Add-OfficePowerPointTextBox -Slide $slide -Text "Weekly Status" -X 80 -Y 60 -Width 520 -Height 50
Add-OfficePowerPointBullets -Slide $slide -Bullets @(
"Shipped v3.2 to production",
"Resolved 14 customer tickets",
"Completed security audit"
) -X 80 -Y 150 -Width 520 -Height 220
$ppt | Save-OfficePowerPoint
Compatibility
| Platform | PowerShell Version | Supported |
|---|---|---|
| Windows | 5.1 | Yes |
| Windows | 7+ | Yes |
| Linux | 7+ | Yes |
| macOS | 7+ | Yes |
PSWriteOffice is available from the PowerShell Gallery and includes generated help for its cmdlet surface.
Related guides
| Guide | Description |
|---|---|
| PSWriteOffice overview | Start with installation, command families, and module scope. |
| PowerPoint cmdlets | Build generated decks with slides, bullets, tables, and images. |
| Markdown cmdlets | Generate Markdown reports and repository-friendly docs from scripts. |
| Database reporting | Connect DbaClientX queries and bulk writes to Excel and CSV artifacts. |
| Performance evidence | Reproduce the PowerForge-backed Excel and CSV comparisons. |
| OfficeIMO roadmap | See open cross-package work without mixing it into current command documentation. |
| PowerShell API reference | Browse the full cmdlet surface with parameters and examples. |
Related packages
| Package | Description |
|---|---|
| OfficeIMO.Word | .NET library powering Word document creation |
| OfficeIMO.Excel | .NET library powering Excel workbook creation |
| OfficeIMO.PowerPoint | .NET library powering PowerPoint presentation creation |
