Set-OfficeExcelColumnGroup

Aliases: ExcelColumnGroup

Namespace PSWriteOffice

Aliases

ExcelColumnGroup

Inputs

None

Outputs

System.Object

Source

Sources/PSWriteOffice/Cmdlets/Excel/SetOfficeExcelColumnGroupCommand.cs:16 Edit on GitHub

Configures collapsible Excel outline grouping for worksheet columns.

Remarks

Configures collapsible Excel outline grouping for worksheet columns.

Examples

Authored help example

Group detail columns and collapse them.

PS>


ExcelSheet 'Data' { Set-OfficeExcelColumnGroup -StartColumn B -EndColumn D -Collapsed }

Applies Excel column outline metadata using OfficeIMO.

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

Set-OfficeExcelColumnGroup [-Clear] [-Collapsed] [-EndColumn <Object>] [-EndColumnName <String>] [-Hidden] [-KeepHidden] [-OutlineLevel <Int32>] [-StartColumn <Object>] [-StartColumnName <String>] [-SummaryRight <Nullable`1>] [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

Clear SwitchParameter optionalposition: namedpipeline: False: Clear column grouping metadata from the target range.
Collapsed SwitchParameter optionalposition: namedpipeline: False: Hide the grouped columns and mark the following summary column as collapsed.
EndColumn Object optionalposition: 1pipeline: False: Last 1-based column in the group. Defaults to the start column.
EndColumnName String optionalposition: namedpipeline: Falsealiases: EndColumnLetter: Last column letter in the group.
Hidden SwitchParameter optionalposition: namedpipeline: False: Hide the grouped columns without marking the group collapsed.
KeepHidden SwitchParameter optionalposition: namedpipeline: False: Keep hidden columns hidden when clearing column grouping metadata.
OutlineLevel Int32 optionalposition: namedpipeline: False: Excel outline level from 1 through 7.
StartColumn Object optionalposition: 0pipeline: Falsealiases: Column: First 1-based column in the group.
StartColumnName String optionalposition: namedpipeline: Falsealiases: ColumnLetter, ColumnName, Letter, StartColumnLetter: First column letter in the group.
SummaryRight Nullable`1 optionalposition: namedpipeline: False: Set whether column summary controls appear to the right of grouped columns.

Outputs

System.Object