API Reference
Cmdlet
Set-OfficeExcelSheetTabColor
Sets or clears the worksheet tab color.
Remarks
Sets or clears the worksheet tab color.
Examples
Set a worksheet tab color.
PS>
ExcelSheet 'Data' { Set-OfficeExcelSheetTabColor -Color '#336699' }
Applies the color to the active worksheet tab.
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-OfficeExcelSheetTabColor [-Clear] [-Color <String>] [-PassThru] [<CommonParameters>]Parameter set:
ContextParameters
- Clear SwitchParameter
- Clear the worksheet tab color.
- Color String
- Named color, RGB hex, or RGBA hex value.
- PassThru SwitchParameter
- Emit the worksheet after applying the tab color.
Outputs
System.Object
Set-OfficeExcelSheetTabColor [-Clear] [-Color <String>] -Document <ExcelDocument> [-PassThru] [-Sheet <String>] [-SheetIndex <Nullable`1>] [<CommonParameters>]Parameter set:
DocumentParameters
- Clear SwitchParameter
- Clear the worksheet tab color.
- Color String
- Named color, RGB hex, or RGBA hex value.
- Document ExcelDocument
- Workbook to operate on outside the DSL context.
- PassThru SwitchParameter
- Emit the worksheet after applying the tab color.
- Sheet String
- Worksheet name when using Document.
- SheetIndex Nullable`1
- Worksheet index (0-based) when using Document.
Outputs
System.Object