Project

PSWriteOffice

PowerShell document automation across Word, Excel, PowerPoint, PDF, Reader, Confluence, Visio, and open text formats.

Stars 159

Forks 14

PowerShell Gallery downloads 158,661

Release v3.0.5

Language: C# Updated: 2026-09-03

API Reference

Cmdlet

New-OfficeExcelDashboard

Aliases: ExcelDashboard

Namespace PSWriteOffice

Aliases

ExcelDashboard

Inputs

System.Object

Outputs

System.Management.Automation.PSObject

Source

Sources/PSWriteOffice/Cmdlets/Excel/NewOfficeExcelDashboardCommand.cs:21 Edit on GitHub

Builds a worksheet dashboard from tabular data using OfficeIMO dashboard defaults.

Remarks

Builds a worksheet dashboard from tabular data using OfficeIMO dashboard defaults.

Examples

Authored help example

Create a dashboard table and chart.

PS>


$rows | New-OfficeExcelDashboard -Title 'Sales Dashboard' -TableName Sales -ChartPreset CompactComparison

Writes a table and chart into the current Excel DSL worksheet.

Common Parameters

This command supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable.

For more information, see about_CommonParameters.

Syntax

New-OfficeExcelDashboard [-ChartColumn <Int32>] [-ChartPreset <Comparison|Trend|Contribution|CompactComparison>] [-ChartRow <Int32>] [-ChartTitle <String>] -InputObject <Object> [-NoAutoFilter] [-NoAutoFit] [-NoChart] [-PassThru] [-Subtitle <String>] [-TableColumn <Int32>] [-TableName <String>] [-TableRow <Int32>] [-TableStyle <TableStyleLight1>] [-Title <String>] [<CommonParameters>]

Parameter set: Context

Parameters

ChartColumn Int32 optionalposition: namedpipeline: False: Top-left chart column.
ChartPreset ExcelDashboardChartPreset optionalposition: namedpipeline: Falsevalues: 4: Dashboard chart preset.; Possible values: Comparison, Trend, Contribution, CompactComparison
ChartRow Int32 optionalposition: namedpipeline: False: Top-left chart row.
ChartTitle String optionalposition: namedpipeline: False: Chart title. Defaults to Title when omitted.
InputObject Object requiredposition: 0pipeline: True (ByValue)aliases: Data, DataTable: Rows to render in the dashboard table.
NoAutoFilter SwitchParameter optionalposition: namedpipeline: False: Disable AutoFilter dropdowns on the generated table.
NoAutoFit SwitchParameter optionalposition: namedpipeline: False: Disable auto-fit for generated table columns.
NoChart SwitchParameter optionalposition: namedpipeline: False: Do not create a chart.
PassThru SwitchParameter optionalposition: namedpipeline: False: Emit dashboard build metadata.
Subtitle String optionalposition: namedpipeline: False: Dashboard subtitle.
TableColumn Int32 optionalposition: namedpipeline: False: Top-left column for the generated table.
TableName String optionalposition: namedpipeline: False: Name for the generated table.
TableRow Int32 optionalposition: namedpipeline: False: Top-left row for the generated table.
TableStyle ExcelTableStyle optionalposition: namedpipeline: Falsevalues: 60: Built-in table style.; Possible values: TableStyleLight1, TableStyleLight2, TableStyleLight3, TableStyleLight4, TableStyleLight5, TableStyleLight6, TableStyleLight7, TableStyleLight8, TableStyleLight9, TableStyleLight10, TableStyleLight11, TableStyleLight12, TableStyleLight13, TableStyleLight14, TableStyleLight15, TableStyleLight16, TableStyleLight17, TableStyleLight18, TableStyleLight19, TableStyleLight20, TableStyleLight21, TableStyleMedium1, TableStyleMedium2, TableStyleMedium3, TableStyleMedium4, TableStyleMedium5, TableStyleMedium6, TableStyleMedium7, TableStyleMedium8, TableStyleMedium9, TableStyleMedium10, TableStyleMedium11, TableStyleMedium12, TableStyleMedium13, TableStyleMedium14, TableStyleMedium15, TableStyleMedium16, TableStyleMedium17, TableStyleMedium18, TableStyleMedium19, TableStyleMedium20, TableStyleMedium21, TableStyleMedium22, TableStyleMedium23, TableStyleMedium24, TableStyleMedium25, TableStyleMedium26, TableStyleMedium27, TableStyleMedium28, TableStyleDark1, TableStyleDark2, TableStyleDark3, TableStyleDark4, TableStyleDark5, TableStyleDark6, TableStyleDark7, TableStyleDark8, TableStyleDark9, TableStyleDark10, TableStyleDark11
Title String optionalposition: namedpipeline: False: Dashboard title.

Outputs

System.Management.Automation.PSObject

New-OfficeExcelDashboard [-ChartColumn <Int32>] [-ChartPreset <Comparison|Trend|Contribution|CompactComparison>] [-ChartRow <Int32>] [-ChartTitle <String>] -InputObject <Object> [-NoAutoFilter] [-NoAutoFit] [-NoChart] [-PassThru] -Path <String> [-Sheet <String>] [-SheetIndex <Int32>] [-Subtitle <String>] [-TableColumn <Int32>] [-TableName <String>] [-TableRow <Int32>] [-TableStyle <TableStyleLight1>] [-Title <String>] [<CommonParameters>]

Parameter set: Path

Parameters

ChartColumn Int32 optionalposition: namedpipeline: False: Top-left chart column.
ChartPreset ExcelDashboardChartPreset optionalposition: namedpipeline: Falsevalues: 4: Dashboard chart preset.; Possible values: Comparison, Trend, Contribution, CompactComparison
ChartRow Int32 optionalposition: namedpipeline: False: Top-left chart row.
ChartTitle String optionalposition: namedpipeline: False: Chart title. Defaults to Title when omitted.
InputObject Object requiredposition: 0pipeline: True (ByValue)aliases: Data, DataTable: Rows to render in the dashboard table.
NoAutoFilter SwitchParameter optionalposition: namedpipeline: False: Disable AutoFilter dropdowns on the generated table.
NoAutoFit SwitchParameter optionalposition: namedpipeline: False: Disable auto-fit for generated table columns.
NoChart SwitchParameter optionalposition: namedpipeline: False: Do not create a chart.
PassThru SwitchParameter optionalposition: namedpipeline: False: Emit dashboard build metadata.
Path String requiredposition: namedpipeline: Falsealiases: FilePath, InputPath: Workbook path to update.
Sheet String optionalposition: namedpipeline: Falsealiases: SheetName, Worksheet: Worksheet name when using Path or Document.
SheetIndex Int32 optionalposition: namedpipeline: False: Worksheet index (0-based) when using Path or Document.
Subtitle String optionalposition: namedpipeline: False: Dashboard subtitle.
TableColumn Int32 optionalposition: namedpipeline: False: Top-left column for the generated table.
TableName String optionalposition: namedpipeline: False: Name for the generated table.
TableRow Int32 optionalposition: namedpipeline: False: Top-left row for the generated table.
TableStyle ExcelTableStyle optionalposition: namedpipeline: Falsevalues: 60: Built-in table style.; Possible values: TableStyleLight1, TableStyleLight2, TableStyleLight3, TableStyleLight4, TableStyleLight5, TableStyleLight6, TableStyleLight7, TableStyleLight8, TableStyleLight9, TableStyleLight10, TableStyleLight11, TableStyleLight12, TableStyleLight13, TableStyleLight14, TableStyleLight15, TableStyleLight16, TableStyleLight17, TableStyleLight18, TableStyleLight19, TableStyleLight20, TableStyleLight21, TableStyleMedium1, TableStyleMedium2, TableStyleMedium3, TableStyleMedium4, TableStyleMedium5, TableStyleMedium6, TableStyleMedium7, TableStyleMedium8, TableStyleMedium9, TableStyleMedium10, TableStyleMedium11, TableStyleMedium12, TableStyleMedium13, TableStyleMedium14, TableStyleMedium15, TableStyleMedium16, TableStyleMedium17, TableStyleMedium18, TableStyleMedium19, TableStyleMedium20, TableStyleMedium21, TableStyleMedium22, TableStyleMedium23, TableStyleMedium24, TableStyleMedium25, TableStyleMedium26, TableStyleMedium27, TableStyleMedium28, TableStyleDark1, TableStyleDark2, TableStyleDark3, TableStyleDark4, TableStyleDark5, TableStyleDark6, TableStyleDark7, TableStyleDark8, TableStyleDark9, TableStyleDark10, TableStyleDark11
Title String optionalposition: namedpipeline: False: Dashboard title.

Outputs

System.Management.Automation.PSObject

New-OfficeExcelDashboard [-ChartColumn <Int32>] [-ChartPreset <Comparison|Trend|Contribution|CompactComparison>] [-ChartRow <Int32>] [-ChartTitle <String>] -Document <ExcelDocument> -InputObject <Object> [-NoAutoFilter] [-NoAutoFit] [-NoChart] [-PassThru] [-Sheet <String>] [-SheetIndex <Int32>] [-Subtitle <String>] [-TableColumn <Int32>] [-TableName <String>] [-TableRow <Int32>] [-TableStyle <TableStyleLight1>] [-Title <String>] [<CommonParameters>]

Parameter set: Document

Parameters

ChartColumn Int32 optionalposition: namedpipeline: False: Top-left chart column.
ChartPreset ExcelDashboardChartPreset optionalposition: namedpipeline: Falsevalues: 4: Dashboard chart preset.; Possible values: Comparison, Trend, Contribution, CompactComparison
ChartRow Int32 optionalposition: namedpipeline: False: Top-left chart row.
ChartTitle String optionalposition: namedpipeline: False: Chart title. Defaults to Title when omitted.
Document ExcelDocument requiredposition: namedpipeline: False: Workbook to update outside the DSL context.
InputObject Object requiredposition: 0pipeline: True (ByValue)aliases: Data, DataTable: Rows to render in the dashboard table.
NoAutoFilter SwitchParameter optionalposition: namedpipeline: False: Disable AutoFilter dropdowns on the generated table.
NoAutoFit SwitchParameter optionalposition: namedpipeline: False: Disable auto-fit for generated table columns.
NoChart SwitchParameter optionalposition: namedpipeline: False: Do not create a chart.
PassThru SwitchParameter optionalposition: namedpipeline: False: Emit dashboard build metadata.
Sheet String optionalposition: namedpipeline: Falsealiases: SheetName, Worksheet: Worksheet name when using Path or Document.
SheetIndex Int32 optionalposition: namedpipeline: False: Worksheet index (0-based) when using Path or Document.
Subtitle String optionalposition: namedpipeline: False: Dashboard subtitle.
TableColumn Int32 optionalposition: namedpipeline: False: Top-left column for the generated table.
TableName String optionalposition: namedpipeline: False: Name for the generated table.
TableRow Int32 optionalposition: namedpipeline: False: Top-left row for the generated table.
TableStyle ExcelTableStyle optionalposition: namedpipeline: Falsevalues: 60: Built-in table style.; Possible values: TableStyleLight1, TableStyleLight2, TableStyleLight3, TableStyleLight4, TableStyleLight5, TableStyleLight6, TableStyleLight7, TableStyleLight8, TableStyleLight9, TableStyleLight10, TableStyleLight11, TableStyleLight12, TableStyleLight13, TableStyleLight14, TableStyleLight15, TableStyleLight16, TableStyleLight17, TableStyleLight18, TableStyleLight19, TableStyleLight20, TableStyleLight21, TableStyleMedium1, TableStyleMedium2, TableStyleMedium3, TableStyleMedium4, TableStyleMedium5, TableStyleMedium6, TableStyleMedium7, TableStyleMedium8, TableStyleMedium9, TableStyleMedium10, TableStyleMedium11, TableStyleMedium12, TableStyleMedium13, TableStyleMedium14, TableStyleMedium15, TableStyleMedium16, TableStyleMedium17, TableStyleMedium18, TableStyleMedium19, TableStyleMedium20, TableStyleMedium21, TableStyleMedium22, TableStyleMedium23, TableStyleMedium24, TableStyleMedium25, TableStyleMedium26, TableStyleMedium27, TableStyleMedium28, TableStyleDark1, TableStyleDark2, TableStyleDark3, TableStyleDark4, TableStyleDark5, TableStyleDark6, TableStyleDark7, TableStyleDark8, TableStyleDark9, TableStyleDark10, TableStyleDark11
Title String optionalposition: namedpipeline: False: Dashboard title.

Outputs

System.Management.Automation.PSObject