Get-SLCellStyle


Synopsis

Gets the various style settings applied to a cell.

Syntax

Description

Gets the various style settings applied to a cell.The style settings can be either accessed by their name or as a property that is attached to the workbookinstance.

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

-CellReference

The cell whose style settings are to be obtained.

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

-Alignment

Display the alignment settings applied to the specified cell.

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

-Font

Display the font settings applied to the specified cell.

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

-Fill

Display the fill settings applied to the specified cell.

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

-Border

Display the border settings applied to the specified cell.

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

-FormatCode

Display the formatcode settings applied to the specified cell.

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

-Protection

Display the protection settings applied to the specified cell.

Required? False
Position? named
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

Display the various style settings applied to cell d6 on sheet6.

Related links