Automate Excel Workbooks

Excel is the largest PSWriteOffice family with 159 exported commands. It covers workbook creation and reading, sheet and range operations, formulas, styling, tables, charts, pivots, validation, comments, images, links, templates, dashboards, protection, accessibility, comparison, repair, streaming contracts, and direct range or chart image export.

Export rows in one line

Use the pipeline when the job is simply PowerShell objects to a worksheet:

$records | Export-OfficeExcel -Path '.\Revenue.xlsx' -WorksheetName 'Sales' -TableName 'Sales'

Use the object or DSL surface when you need several sheets, formulas, charts, pivots, or precise formatting.

Create a workbook from data

Use New-OfficeExcel with Add-OfficeExcelSheet, then add tables, formulas, charts, and report components inside each sheet context. The report DSL includes titles, paragraphs, sections, callouts, KPI rows, tables, legends, spacers, and dashboard charts for repeatable operational output.

$records = @(
    [pscustomobject]@{ Region = 'EMEA'; Revenue = 98000 }
    [pscustomobject]@{ Region = 'APAC'; Revenue = 143000 }
)

New-OfficeExcel -Path '.\Output\Revenue.xlsx' {
    Add-OfficeExcelSheet -Name 'Sales' {
        Add-OfficeExcelTable -InputObject $records -TableName 'Sales' -AutoFit
        Add-OfficeExcelChart -TableName 'Sales' -Row 2 -Column 5 -Type ColumnClustered -Title 'Revenue by region'
    }
}

Copy complete DSL recipes

• Project tracker: table, validation list, conditional rules, chart, frozen header, print layout, and workbook index.
• Budget dashboard: summary formulas and chart over a separate styled detail sheet.
• Operational dashboard: the larger example with KPIs, pivots, sparklines, charts, links, comments, queries, and validation.

Other Excel workflows

• Object composition: keep a workbook and worksheet object, then add cells and a table incrementally.
• Append or replace rows: update a recurring export without rebuilding the surrounding workbook.
• Template invoice: fill a prepared workbook while preserving its design.
• Pivots and sparklines: build analytical views beyond a flat export.

The DSL cookbook shows how Excel composition differs from the Word, PowerPoint, PDF, and Markdown blocks that consume the same objects.

Task guides

• Read and import data
• Update existing workbooks
• Merge and compare workbooks
• Validate and repair workbooks
• Import, export, and publish

Work with existing workbooks

The read surface can return used ranges, tables, named ranges, formulas, comments, validation, rich text, worksheet views, page breaks, pivots, summaries, preflight data, and streaming capabilities. Targeted commands update cells, rows, columns, styles, formulas, links, page setup, print settings, themes, worksheet visibility, active sheet, filters, and write reservations.

Validate before delivery

• Get-OfficeExcelPreflight and Get-OfficeExcelRuntimePreflight report readiness before an operation.
• Test-OfficeExcelWorkbook checks workbook integrity.
• Test-OfficeExcelAccessibility supports accessible-delivery gates.
• Compare-OfficeExcelWorkbook and Compare-OfficeExcelRange make change evidence explicit.
• Repair-OfficeExcelWorkbook is a deliberate repair path, not an implicit side effect of reading.

Templates, joins, merges, sheet ordering, workbook copying, HTML review, and delimited import/export cover the surrounding pipeline. Search the command reference for OfficeExcel; use the Excel examples for end-to-end patterns.