Skip to main content
SearchCtrl K
Community

Source code

OfficeIMO.NET libraries, PowerShell module, CLI, Studio and browser tools 606 stars

Talk and help

DiscordQuestions, ideas and show and tell Report an issueBugs and feature requests SponsorFund ongoing development

Mode

Background

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Search the whole siteOpen search page →
Documentation Search all OfficeIMO/
Cmdlet

Get-OfficeExcelTableStyle

Aliases: ExcelTableStyle
Module PSWriteOffice
Aliases
ExcelTableStyle
Inputs
None
Source
GetOfficeExcelTableStyleCommand.cs:18 Edit on GitHub

Lists built-in Excel table styles and compatibility recommendations.

Syntax

Get-OfficeExcelTableStyle [-Profile <Desktop|CrossHost>] [-RecommendedOnly] [<CommonParameters>]
#
Parameter set: All Parameter Sets

Examples

Authored help example

Show table styles recommended for cross-host workbooks.

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.

Parameters

-Profile ExcelTableStyleCompatibilityProfile optional
Compatibility profile used to evaluate table styles.
Possible values: Desktop, CrossHost
-RecommendedOnly SwitchParameter optional
Return only styles recommended for the selected profile.

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.