Get-SLDefinedName


Synopsis

Lists defined names contained in an excel document.

Syntax

Description

Lists defined names contained in an excel document.The properties associated with a defined name are:
Name,Text,Comment & LocalsheetID(scope).

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

-DefinedName

Gets matching defined names. Filter can be a string or a regex pattern.

Required? True
Position? 1
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,SpreadsheetLight.SLDocument

Outputs

SpreadsheetLight.SLDocument

Notes

Examples

Example 1

Will list all defined names in document &;39;myfirstdoc&;39;.

Example 2

Will list all defined names matching the string &;39;dfname&;39;.

Related links