Cmdlet
Export-OfficePowerPoint
Exports objects as a designed presentation with editable tables and optional charts.
Syntax
Export-OfficePowerPoint
[-Accent <OfficeColor>]
[-Category <String>]
[-ChartTitle <String>]
[-ChartType <OfficeChartType>]
[-Culture <CultureInfo>]
[-GroupBy <String>]
-InputObject <Object[]>
[-MaxRows <Int32>]
[-NoClobber]
[-NoSummary]
[-NoTable]
[-PassThru]
[-Path] <String>
[-Property <String[]>]
[-Show]
[-Subtitle <String>]
[-Theme <OfficeThemeInput>]
[-Title <String>]
[-Value <String[]>]
[<CommonParameters>]#Parameter set:
PathDescription
Creates a title slide, an optional grouped summary, repeating table headers and native continuation slides. Replaces an existing file unless NoClobber is supplied. Output is quiet unless PassThru is supplied; publication is atomic.
Examples
Present regional revenue with a chart.
$sales | Export-OfficePowerPoint -Path ./Sales.pptx -Title 'Regional sales' -Property Region,Revenue -Category Region -Value Revenue -Theme Boardroom -PassThruParameters
- -Accent OfficeColor
- Brand accent, resolved against the selected theme.
- -Category String
- Property containing chart categories.
- -ChartTitle String
- Chart slide title; omission uses the category property name.
- -ChartType OfficeChartType
- Shared native chart kind; defaults to clustered columns.
- Possible values:
ColumnClustered,Column,ColumnStacked,ColumnStacked100,BarClustered,Bar,BarStacked,BarStacked100,Line,LineStacked,LineStacked100,Area,AreaStacked,AreaStacked100,Scatter,Radar,Pie,Doughnut,Bubble,Column3DClustered,Column3DStacked,Column3DStacked100,Bar3DClustered,Bar3DStacked,Bar3DStacked100,Line3D,Area3D,Area3DStacked,Area3DStacked100,Pie3D,PieOfPie,BarOfPie,Stock,Surface,SurfaceWireframe,SurfaceContour,Funnel,Waterfall,BoxWhisker,Treemap,SurfaceContourWireframe,Sunburst - -Culture CultureInfo
- Culture for displayed cell values, group counts and numeric chart input; defaults to invariant.
- -GroupBy String
- Property counted on the summary; omission tries Category, then a text property with two to six groups.
- -InputObject Object[]
- Objects supplied as an array or through the pipeline.
- -MaxRows Int32
- Maximum data rows per physical table slide; omission uses native readable capacity.
- -NoClobber SwitchParameter
- Refuse to replace an existing destination.
- -NoSummary SwitchParameter
- Omit the At a glance summary.
- -NoTable SwitchParameter
- Export only title and chart slides; requires Category and Value.
- -PassThru SwitchParameter
- Return the saved FileInfo.
- -Path String
- Destination PPTX file; its parent folder is created only when publishing.
- -Property String[]
- Table properties in display order; omission includes all properties.
- -Show SwitchParameter
- Open the saved presentation using the system's default application.
- -Subtitle String
- Subtitle on the opening slide.
- -Theme OfficeThemeInput
- Built-in theme, OfficeTheme model or PowerPoint template path; defaults to Modern.
- -Title String
- Title slide text; omission uses the destination file name without its extension.
- -Value String[]
- Numeric properties plotted as chart series in the supplied order.
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.