Set-SLWorksheetTabColor


Synopsis

Sets the tab color of a worksheet.

Syntax

Description

Sets the tab color of a worksheet.

Parameters

-WorkBookInstance

Instance of an excel document that can be used for editing.

Required? True
Position? 0
Default value  
Accept pipeline input? true (ByValue)
Accept wildcard characters? False

-WorksheetName

Name of the Worksheet that is to be processed.

Required? True
Position? 1
Default value  
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? False

-Color

Any color that is to be used eg: Red.

Required? True
Position? 2
Default value  
Accept pipeline input? false
Accept wildcard characters? False

-ThemeColor

Theme color to be used. Valid values are:
&;39;Light1Color&;39;,&;39;Dark1Color&;39;,&;39;Light2Color&;39;,&;39;Dark2Color&;39;,&;39;Accent1Color&;39;,&;39;Accent2Color&;39;,&;39;Accent3Color&;39;,
&;39;Accent4Color&;39;,&;39;Accent5Color&;39;,&;39;Accent6Color&;39;,&;39;Hyperlink&;39;,&;39;FollowedHyperlinkColor&;39;

Required? True
Position? 2
Default value  
Accept pipeline input? false
Accept wildcard characters? False

This cmdlet supports the common parameters: Verbose, Debug,
ErrorAction, ErrorVariable, WarningAction, WarningVariable,
OutBuffer, PipelineVariable, and OutVariable. For more information, see
about_CommonParameters (http://go.microsoft.com/fwlink/?LinkID=113216).

Inputs

String,SpreadsheetLight.SLDocument

Outputs

SpreadsheetLight.SLDocument

Notes

Examples

Example 1

Set the tab color of sheet2 to yellow.

Example 2

Set the tab color of sheet2 to Accent2Color.

Related links