Add-OfficeExcelReportSection

Aliases: ExcelReportSection

Namespace PSWriteOffice

Aliases

ExcelReportSection

Inputs

None

Outputs

System.Object

Adds a section heading to the current Excel report sheet.

Remarks

Adds a section heading to the current Excel report sheet.

Examples

Authored help example

Add a section and paragraph to a report sheet.

PS>


New-OfficeExcel -Path .\Operations.xlsx {
                Add-OfficeExcelReportSheet -Name Summary {
                    Add-OfficeExcelReportSection -Text 'Service health'
                    Add-OfficeExcelReportParagraph -Text 'All monitored services are reporting.'
                }
            }

Uses the report composer to add a section heading and narrative text.

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-OfficeExcelReportSection -Text <String> [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

Text String requiredposition: 0pipeline: False: Section heading text.

Outputs

System.Object