Add-OfficeExcelReportSpacer

Aliases: ExcelReportSpacer

Namespace PSWriteOffice

Aliases

ExcelReportSpacer

Inputs

None

Source

Sources/PSWriteOffice/Cmdlets/Excel/OfficeExcelReportBlockCommands.cs:114 Edit on GitHub

Adds vertical spacing to the current Excel report sheet.

Remarks

Adds vertical spacing to the current Excel report sheet.

Examples

Authored help example

Add spacing between report blocks.

PS>


New-OfficeExcel -Path .\Operations.xlsx {
                Add-OfficeExcelReportSheet -Name Summary {
                    Add-OfficeExcelReportTitle -Title 'Operational Summary'
                    Add-OfficeExcelReportSpacer -Rows 2
                    Add-OfficeExcelReportSection -Text 'Details'
                }
            }

Advances the composer cursor before adding the next report block.

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

Add-OfficeExcelReportSpacer [-PassThru] [-Rows <Int32>] [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

PassThru SwitchParameter optionalposition: namedpipeline: False: Emit the object created or changed by the command.
Rows Int32 optionalposition: 0pipeline: False: Rows to advance. Defaults to the composer theme spacing.