Add-OfficeExcelReportSpacer

Aliases: ExcelReportSpacer

Namespace PSWriteOffice

Aliases

ExcelReportSpacer

Inputs

None

Outputs

System.Object

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 [-Rows <Int32>] [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

Rows Int32 optionalposition: 0pipeline: False: Rows to advance. Defaults to the composer theme spacing.

Outputs

System.Object