Cmdlet

Add-OfficeExcelReportSpacer

Aliases: ExcelReportSpacer

Module PSWriteOffice

Aliases

ExcelReportSpacer

Inputs

None

Source

OfficeExcelReportBlockCommands.cs:114 Edit on GitHub

Adds vertical spacing to the current Excel report sheet.

Syntax

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

Parameter set: All Parameter Sets

Examples

Authored help example

Add spacing between report blocks.

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.

Parameters

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

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.