Get-OfficeExcelTableStyle

Aliases: ExcelTableStyle

Namespace PSWriteOffice

Aliases

ExcelTableStyle

Inputs

None

Outputs

System.Object

Source

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

Lists built-in Excel table styles and compatibility recommendations.

Remarks

Lists built-in Excel table styles and compatibility recommendations.

Examples

Authored help example

Show table styles recommended for cross-host workbooks.

PS>


Get-OfficeExcelTableStyle -RecommendedOnly |
                Sort-Object Name |
                Format-Table Name, Profile

Uses OfficeIMO's table style catalog to return styles that are broadly stable across desktop, web, and spreadsheet viewers.

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

Get-OfficeExcelTableStyle [-Profile <Desktop|CrossHost>] [-RecommendedOnly] [<CommonParameters>]

Parameter set: All Parameter Sets

Parameters

Profile ExcelTableStyleCompatibilityProfile optionalposition: namedpipeline: Falsevalues: 2: Compatibility profile used to evaluate table styles.; Possible values: Desktop, CrossHost
RecommendedOnly SwitchParameter optionalposition: namedpipeline: False: Return only styles recommended for the selected profile.

Outputs

System.Object