Automate Excel Workbooks

Excel is the largest PSWriteOffice family with 155 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, and streaming contracts.

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'
    }
}

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.