Show-SLGridLines


Synopsis

Show Gridlines from one or more worksheets.

Syntax

Description

Show Gridlines from one or more worksheets.

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 where gridlines are to be shown.

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

-All

If specified will show gridlines from all worksheets within a workbook( assuming they have been hidden ).
The user does not need to use the worksheetname parameter in conjunction with the all parameter.

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

Show gridlines from sheet1 & sheet3 contained in MyFirstDoc.

Example 2

Show gridlines from all worksheets contained in MyFirstDoc.

Related links