Hide-SLGridLines


Synopsis

Removes Gridlines from one or more worksheets.

Syntax

Description

Removes 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 from which gridlines are to be removed.

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

-All

If specified will remove gridlines from all worksheets within a workbook.
The user does not and should 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

Remove gridlines from sheet1 & sheet3 contained in MyFirstDoc.

Example 2

Remove gridlines from all worksheets contained in MyFirstDoc.

Related links