Hide-SLColumn


Synopsis

Hide columns by name or index.

Syntax

Description

Hide columns by name or index.

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? False
Position? 1
Default value  
Accept pipeline input? true (ByPropertyName)
Accept wildcard characters? False

-ColumnName

The columnName to be hidden. Eg: B.

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

-ColumnIndex

The columnIndex to be hidden. Eg: 3.

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

-StartColumnName

The columnName from which columns are to be hidden. Eg: B.

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

-ENDColumnName

The columnName upto which columns are to be hidden. Eg: D.

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

-StartColumnIndex

The columnIndex from which columns are to be hidden. Eg: 3.

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

-ENDColumnIndex

The columnIndex upto which columns are to be hidden. Eg: 5.

Required? True
Position? 3
Default value  
Accept pipeline input? true (ByPropertyName)
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,Int,SpreadsheetLight.SLDocument

Outputs

SpreadsheetLight.SLDocument

Notes

Examples

Example 1

Hide column B.

Example 2

Hide column 3(column C).

Example 3

Hide columns B to C.

Example 4

Hide columns 4 to 5.

Related links